{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Description","Dashboard","Expenditure","Learner Numbers","Enrolments","Enrol Scenarios","Funding Descr","Funding Dashboard","Funding Shortfall","Funding over time","TVET & CET Funding","Infrastructure"],"not_rendered":{"charts":4,"images":2,"macros":1,"external_links":11,"defined_names":47,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Description","index":0,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,"Model Layout"]
[null,null,"This model forms part of the broader post school education and training (PSET) system costing initiative\n\n"]
[null,null,"'This model forecasts  expenditure of the Community Colleges up to 2030 based on the targets and objectives of White Paper on Post-School Education."]

{"sheet":"Dashboard","index":1,"n_rows":19,"n_cols":38,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,13,2,15],[10,4,10,5],[10,6,10,7],[1,12,2,12],[1,2,2,7],[5,2,6,2]]}
[]
[null,null,"INPUTS & ASSUMPTIONS",null,null,null,null,null,null,null,null,null,"OUTPUTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CPI Inflation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2030,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Real",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Status quo","Full Policy","Mixed",2014,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nominal",6.2E-2]
[null,null,null,null,"Status quo","Full Policy","Mixed",2014,null,null,null,null,"Total Spending (R'm) 2030",{"$f":"Expenditure!S39/1000000","v":14163.289965590888},{"$f":"Expenditure!S51/1000000","v":17956.347603402424},{"$f":"Expenditure!S63/1000000","v":12283.744322448772},{"$f":"Expenditure!C39/1000000","v":1843.8189689996782}]
[null,null,"Enrolment scenarios","Target Enrolments (2030)",1000000,1000000,750000,{"$f":"Enrolments!C2","v":262621},null,null,null,null,"Total number of completions",{"$f":"'Learner Numbers'!S35","v":125713},{"$f":"'Learner Numbers'!S39","v":341249},{"$f":"'Learner Numbers'!S43","v":203685},{"$f":"'Learner Numbers'!C35","v":33015}]
[null,null,null,"Occupational % enrol",2.9000000000000001E-2,0.35,0.25,{"$f":"E7","v":2.9000000000000001E-2},null,null,null,null,"Total Cumulative Spending (R'm)",{"$f":"Expenditure!T39/1000000","v":111565.00957758837},{"$f":"Expenditure!T51/1000000","v":151165.19841672634},{"$f":"Expenditure!T63/1000000","v":107605.3328431371},"N/A"]
[null,null,"Performance","AET Throughput %",0.17452550154948801,0.2,0.17452550154948801,0.17452550154948801,null,null,null,null,"Infrastructure Spend (R'm)",{"$f":"Infrastructure!R30","v":0},{"$f":"Infrastructure!R31/1000000","v":3134.5081436850119},{"$f":"Infrastructure!R32/1000000","v":695.8625795076133},"N/A"]
[null,null,"Student:Lecturer ratio","All enrolments",18.256116541119344,23,23,{"$f":"Expenditure!C8","v":18},null,null,null,null,"Cumulative Infrastructure Spend",{"$f":"Infrastructure!S30","v":0},{"$f":"Infrastructure!S31/1000000","v":31995.982243521212},{"$f":"Infrastructure!S32/1000000","v":7084.5407409664995},"N/A"]
[null,null,"Direct Costs","Direct Learner Cost",214,3600,2600,525,null,null,null,null,"Spend per FTE",{"$f":"N5/Enrolments!S90*1000000","v":15522.232256629988},{"$f":"O5/Enrolments!S98*1000000","v":26621.716239291953},{"$f":"P5/Enrolments!S106*1000000","v":21910.803696675626},{"$f":"Q5/Enrolments!C90*1000000","v":7694.4726235937742}]
[null,null,"Inflation","PSET Inflation","Nominal",null,{"$f":"IF(E11=AK3,AL3,AL4)","v":6.2E-2},null,null,null,null,null,"Spend per graduate",{"$f":"N5/N6*1000000","v":112663.68605944404},{"$f":"O5/O6*1000000","v":52619.487832645442},{"$f":"P5/P6*1000000","v":60307.554912972351},{"$f":"Q5/Q6*1000000","v":55847.916674229229}]
[]
[]
[]
[null,null,null,"Heading"]
[null,null,null,"Item description"]
[null,null,null,"User-defined Input"]
[null,null,null,"Fixed Assumption"]
[null,null,null,"Key output"]

{"sheet":"Expenditure","index":2,"n_rows":71,"n_cols":21,"rows_kept":71,"cut":false,"hidden":false,"merged":[[15,0,18,0],[19,0,20,0],[11,0,13,0],[5,0,9,0],[3,5,3,9],[4,5,4,9],[5,5,5,9],[6,5,6,9],[7,5,7,9],[8,5,8,9],[9,5,9,9],[10,5,10,9],[11,5,11,9],[12,5,12,9],[18,5,18,9],[19,5,19,9],[20,5,20,9],[21,5,21,9],[13,5,13,9],[14,5,14,9],[15,5,15,9],[16,5,16,9],[17,5,17,9]]}
[]
[]
[]
[null,null,{"$f":"Dashboard!N4","v":"Status quo"},{"$f":"Dashboard!O4","v":"Full Policy"},{"$f":"Dashboard!P4","v":"Mixed"},"Assumptions"]
[null,"CPI Inflation (%)",{"$f":"'Funding Dashboard'!E8","v":0},{"$f":"'Funding Dashboard'!F8","v":0},{"$f":"'Funding Dashboard'!G8","v":0}]
["Lecturing Costs","Average salary per educator",83914,274177.4487895717,274177.4487895717,"Based on existing data and average hours worked per week"]
[null,"Number of lecturers",16063,3790,3790,"Current existing lecturers employed"]
[null,"Lecturer:Student ratio",18,{"$f":"Dashboard!F9","v":23},{"$f":"Dashboard!G9","v":23}]
[null,"Wage Inflation",{"$f":"Dashboard!G11","v":6.2E-2},"N/A","N/A"]
[null,"Lecturer:Post ratio",1,4,4.3]
[null,"Enrolmentts",{"$f":"Dashboard!E6","v":1000000},{"$f":"Dashboard!F6","v":1000000},{"$f":"Dashboard!G6","v":750000},"Estimations based on white paper targets"]
[null,"Lecturer development cost (%)",1.0999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2]
[null,"Average salary per centre manager",{"$f":"14000*12","v":168000},{"$f":"14000*12","v":168000},{"$f":"14000*12","v":168000}]
[null,"Direct Learning Cost ",{"$f":"Dashboard!E10","v":214},{"$f":"Dashboard!F10","v":3600},{"$f":"Dashboard!G10","v":2600}]
[null,"Direct Learning Inflation",{"$f":"Dashboard!G11","v":6.2E-2},{"$f":"Dashboard!G11","v":6.2E-2},{"$f":"Dashboard!G11","v":6.2E-2}]
["Indirect Programme Costs ","Number of AET Centres",3276,3276,3276]
[null,"Consumables per centre",6362.6236263736273,6900,6900]
[null,"Centre operational cost",14846.121794871797,36048,26048,"Based on existing PALC data "]
[null,"% centres requiring utility services",0.32,0.32,0.32,"Estimate based on interviews with college principals school "]
["Management and Support","Number of Community Colleges",9,9,9]
[null,"Management and support cost",26976701.947075348,28864833.333333332,28864833.333333332,"Based on data provided by DHET on provincial support"]
[null,"Proportion of additional learners requiring college infrastructure",0,0.5,0.15,"Based on DHET Infrastructure costingestimates"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S25/SUM(Enrolments!S91:S95)","v":15111.996462560783}]
[]
[null,null,{"$f":"C39-C38","v":1729578833.9996781},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S39-S38","v":13701319965.590887}]
[]
[]
[null,null,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,null,{"$f":"(T48-S23)/S23","v":0.35528998602878964}]
[null,"Lecturing costs",{"$f":"C31*$C$7","v":1347910582},{"$f":"D31*D$30","v":1451849147.648},{"$f":"E31*E$30","v":1789598435.9486976},{"$f":"F31*F$30","v":2163647727.875123},{"$f":"G31*G$30","v":2577199915.612638},{"$f":"H31*H$30","v":3033715512.7636533},3536932287.4857798,4090886339.8423862,4699934726.978117,5368779747.0283241,6102495000.4742527,6906553355.9998999,7786856956.8289042,8749769413.0602436,9802150335.7222176,10951392379.170471,12205460970.115788]
[null,"Lecturers required",{"$f":"C7","v":16063},{"$f":"Enrolments!D2/Expenditure!$C$8","v":16291.555555555555},{"$f":"Enrolments!E2/Expenditure!$C$8","v":18909.155555555553},{"$f":"Enrolments!F2/Expenditure!$C$8","v":21526.755555555555},{"$f":"Enrolments!G2/Expenditure!$C$8","v":24144.355555555554},{"$f":"Enrolments!H2/Expenditure!$C$8","v":26761.955555555553},{"$f":"Enrolments!I2/Expenditure!$C$8","v":29379.555555555555},{"$f":"Enrolments!J2/Expenditure!$C$8","v":31997.155555555557},{"$f":"Enrolments!K2/Expenditure!$C$8","v":34614.755555555559},{"$f":"Enrolments!L2/Expenditure!$C$8","v":37232.355555555565},{"$f":"Enrolments!M2/Expenditure!$C$8","v":39849.955555555563},{"$f":"Enrolments!N2/Expenditure!$C$8","v":42467.555555555569},{"$f":"Enrolments!O2/Expenditure!$C$8","v":45085.155555555568},{"$f":"Enrolments!P2/Expenditure!$C$8","v":47702.755555555574},{"$f":"Enrolments!Q2/Expenditure!$C$8","v":50320.355555555579},{"$f":"Enrolments!R2/Expenditure!$C$8","v":52937.955555555578},{"$f":"Enrolments!S2/Expenditure!$C$8","v":55555.555555555555}]
[null,"Average lecturer salary",{"$f":"$C$6","v":83914},{"$f":"C31*(1+$C$9)/(1+$C$5)","v":89116.668000000005},{"$f":"D31*(1+$C$9)/(1+$C$5)","v":94641.901416000008},100509.69930379202,106741.30066062712,113359.26130158601,120387.53550228434,127851.56270342598,135778.3595910384,144196.61788568279,153136.80819459513,162631.29030266003,172714.43030142496,183422.72498011333,194794.93392888037,206872.21983247096,219698.29746208419]
[null,"Lecturer development",{"$f":"C29*$C$12","v":14827016.401999999},{"$f":"D29*$C$12","v":15970340.624127999},19685582.795435671,23800125.006626353,28349199.071739018,33370870.640400182,38906255.162343577,44999749.738266245,51699281.996759281,59056577.217311561,67127445.005216777,75972086.915998891,85655426.525117934,96247463.543662667,107823653.69294439,120465316.17087518,134260070.67127365]
[null,"Management and Support",{"$f":"$C$21*$C$20","v":242790317.52367812},{"$f":"C33*(1+$C$9)/(1+$C$5)","v":257843317.21014619},{"$f":"D33*(1+$C$9)/(1+$C$5)","v":273829602.87717527},290807038.25556016,308837074.62740493,327984973.25430405,348320041.59607095,369915884.17502737,392850668.99387908,417207410.47149962,443074269.92073262,470544874.65581805,499718656.88447881,530701213.6113165,563604688.85521817,598548179.56424177,635658166.69722474]
[null,"Indirect costs per centre",{"$f":"$C$17+$C$18","v":21208.745421245425},{"$f":"C34*(1+$C$15)/(1+$C$5)","v":22523.687637362644},{"$f":"D34*(1+$C$15)/(1+$C$5)","v":23920.156270879128},{"$f":"E34*(1+$C$15)/(1+$C$5)","v":25403.205959673636},{"$f":"F34*(1+$C$15)/(1+$C$5)","v":26978.204729173402},{"$f":"G34*(1+$C$15)/(1+$C$5)","v":28650.853422382155},{"$f":"H34*(1+$C$15)/(1+$C$5)","v":30427.206334569852},{"$f":"I34*(1+$C$15)/(1+$C$5)","v":32313.693127313185},{"$f":"J34*(1+$C$15)/(1+$C$5)","v":34317.142101206606},{"$f":"K34*(1+$C$15)/(1+$C$5)","v":36444.80491148142},{"$f":"L34*(1+$C$15)/(1+$C$5)","v":38704.382815993267},{"$f":"M34*(1+$C$15)/(1+$C$5)","v":41104.054550584849},{"$f":"N34*(1+$C$15)/(1+$C$5)","v":43652.505932721113},{"$f":"O34*(1+$C$15)/(1+$C$5)","v":46358.961300549825},{"$f":"P34*(1+$C$15)/(1+$C$5)","v":49233.216901183914},{"$f":"Q34*(1+$C$15)/(1+$C$5)","v":52285.676349057321},{"$f":"R34*(1+$C$15)/(1+$C$5)","v":55527.388282698877}]
[null,"Total indirect costs",{"$f":"C34*$C$16","v":69479850.000000015},{"$f":"D34*$C$16","v":73787600.700000018},78362431.943400025,83220902.723890826,88380598.692772061,93860195.811723948,99679527.952050835,105859658.685078,112422957.52355283,119393180.89001313,126795558.10519394,134656882.70771596,143005609.43559438,151871957.22060123,161288018.56827849,171287875.71951178,181907724.01412153]
[null,"Direct cost per learner",{"$f":"C14","v":214},{"$f":"C36*(1+$C$15)/(1+$C$5)","v":227.268},{"$f":"D36*(1+$C$15)/(1+$C$5)","v":241.35861600000001},{"$f":"E36*(1+$C$15)/(1+$C$5)","v":256.32285019200003},{"$f":"F36*(1+$C$15)/(1+$C$5)","v":272.21486690390407},{"$f":"G36*(1+$C$15)/(1+$C$5)","v":289.09218865194612},{"$f":"H36*(1+$C$15)/(1+$C$5)","v":307.0159043483668},{"$f":"I36*(1+$C$15)/(1+$C$5)","v":326.05089041796555},{"$f":"J36*(1+$C$15)/(1+$C$5)","v":346.26604562387945},{"$f":"K36*(1+$C$15)/(1+$C$5)","v":367.73454045256},{"$f":"L36*(1+$C$15)/(1+$C$5)","v":390.53408196061872},{"$f":"M36*(1+$C$15)/(1+$C$5)","v":414.74719504217711},{"$f":"N36*(1+$C$15)/(1+$C$5)","v":440.46152113479212},{"$f":"O36*(1+$C$15)/(1+$C$5)","v":467.77013544514926},{"$f":"P36*(1+$C$15)/(1+$C$5)","v":496.77188384274854},{"$f":"Q36*(1+$C$15)/(1+$C$5)","v":527.571740640999},{"$f":"R36*(1+$C$15)/(1+$C$5)","v":560.28118856074093}]
[null,"Total direct cost",{"$f":"(C36*C40)","v":54571068.074000001},{"$f":"(D36*D40)","v":64713155.756544001},79767627.728286415,96440096.853796735,114873325.38988282,135221558.53213754,157651399.5212332,182342749.12197915,209489814.09345803,239302189.59377536,272006020.8107568,307845249.4818455,347082951.36415261,390002771.14085764,436910461.70483023,488135535.24647003,544033034.09247947]
[null,"Total occupational Costs",{"$f":"Enrolments!$G$84*Enrolments!C96","v":114240135},{"$f":"(Enrolments!$G$84*Enrolments!D96)*(1+$C$15)/(1+$C$5)","v":135471778.56000003},{"$f":"(Enrolments!$G$84*Enrolments!E96)*(1+$C$15)/(1+$C$5)","v":157238326.65600002},{"$f":"(Enrolments!$G$84*Enrolments!F96)*(1+$C$15)/(1+$C$5)","v":179004874.75199997},{"$f":"(Enrolments!$G$84*Enrolments!G96)*(1+$C$15)/(1+$C$5)","v":200771422.84800002},{"$f":"(Enrolments!$G$84*Enrolments!H96)*(1+$C$15)/(1+$C$5)","v":222537970.94400001},{"$f":"(Enrolments!$G$84*Enrolments!I96)*(1+$C$15)/(1+$C$5)","v":244304519.04000005},{"$f":"(Enrolments!$G$84*Enrolments!J96)*(1+$C$15)/(1+$C$5)","v":266071067.13600004},{"$f":"(Enrolments!$G$84*Enrolments!K96)*(1+$C$15)/(1+$C$5)","v":287837615.23200005},{"$f":"(Enrolments!$G$84*Enrolments!L96)*(1+$C$15)/(1+$C$5)","v":309604163.32800007},{"$f":"(Enrolments!$G$84*Enrolments!M96)*(1+$C$15)/(1+$C$5)","v":331370711.42400008},{"$f":"(Enrolments!$G$84*Enrolments!N96)*(1+$C$15)/(1+$C$5)","v":353137259.52000016},{"$f":"(Enrolments!$G$84*Enrolments!O96)*(1+$C$15)/(1+$C$5)","v":374903807.61600024},{"$f":"(Enrolments!$G$84*Enrolments!P96)*(1+$C$15)/(1+$C$5)","v":396670355.71200019},{"$f":"(Enrolments!$G$84*Enrolments!Q96)*(1+$C$15)/(1+$C$5)","v":418436903.80800027},{"$f":"(Enrolments!$G$84*Enrolments!R96)*(1+$C$15)/(1+$C$5)","v":440203451.90400028},{"$f":"(Enrolments!$G$84*Enrolments!S96)*(1+$C$15)/(1+$C$5)","v":461970000}]
[null,"Total costs",{"$f":"C37+C35+C33+C32+C29+C38","v":1843818968.9996781},1999635340.4988182,2398482007.9489951,2836920765.4669971,3318411536.2424369,3846691081.9462194,4425794030.7574787,5060075448.6987362,5754235064.8177662,6513343268.528924,7342869005.7401524,8248709709.2812786,9237223408.6542492,10315263174.288681,11490214062.35149,12770032737.77557,14163289965.590887,{"$f":"SUM(C39:S39)","v":111565009577.58836}]
["Status Quo",{"$f":"Enrolments!B2:S2","v":"Total Enrolment"},{"$f":"Enrolments!C63","v":255004.99100000001},{"$f":"Enrolments!D63","v":284743.80800000002},{"$f":"Enrolments!E63","v":330494.22080000001},{"$f":"Enrolments!F63","v":376244.6336},{"$f":"Enrolments!G63","v":421995.04639999999},{"$f":"Enrolments!H63","v":467745.45919999992},{"$f":"Enrolments!I63","v":513495.87199999997},{"$f":"Enrolments!J63","v":559246.28480000002},{"$f":"Enrolments!K63","v":604996.69760000007},{"$f":"Enrolments!L63","v":650747.11040000012},{"$f":"Enrolments!M63","v":696497.52320000017},{"$f":"Enrolments!N63","v":742247.93600000022},{"$f":"Enrolments!O63","v":787998.34880000027},{"$f":"Enrolments!P63","v":833748.76160000032},{"$f":"Enrolments!Q63","v":879499.17440000037},{"$f":"Enrolments!R63","v":925249.58720000042},{"$f":"Enrolments!S63","v":971000}]
[null,"Lecturing costs",{"$f":"C42*C43","v":1347910582},{"$f":"D42*D43","v":1431481038.0840001},{"$f":"E42*E43","v":1050663358.8993348},1203707456.6595464,1371690272.5904155,1555875906.2333126,1757627781.040092,1978416101.3393509,2219825852.1654,2483565380.6003308,2771475599.9854693,3085539861.2513371,3427894538.7078285,3800840380.942275,4206854681.007,4648604323.8554087,5128959773.0232258]
[null,"Lecturers required",{"$f":"$C$7","v":16063},{"$f":"C42","v":16063},{"$f":"E52/Expenditure!$D$8/$D$10","v":3359.7197913043478},{"$f":"F52/Expenditure!$D$8/$D$10","v":3624.3981913043472},{"$f":"G52/Expenditure!$D$8/$D$10","v":3889.0765913043479},{"$f":"H52/Expenditure!$D$8/$D$10","v":4153.7549913043467},{"$f":"I52/Expenditure!$D$8/$D$10","v":4418.4333913043474},{"$f":"J52/Expenditure!$D$8/$D$10","v":4683.1117913043481},{"$f":"K52/Expenditure!$D$8/$D$10","v":4947.7901913043488},{"$f":"L52/Expenditure!$D$8/$D$10","v":5212.4685913043495},{"$f":"M52/Expenditure!$D$8/$D$10","v":5477.1469913043493},{"$f":"N52/Expenditure!$D$8/$D$10","v":5741.82539130435},{"$f":"O52/Expenditure!$D$8/$D$10","v":6006.5037913043507},{"$f":"P52/Expenditure!$D$8/$D$10","v":6271.1821913043514},{"$f":"Q52/Expenditure!$D$8/$D$10","v":6535.8605913043521},{"$f":"R52/Expenditure!$D$8/$D$10","v":6800.5389913043527},{"$f":"S52/Expenditure!$D$8/$D$10","v":7065.217391304348}]
[null,"Average lecturer salary",{"$f":"$C$6","v":83914},{"$f":"C43*(1+$C$9)/(1+$C$5)","v":89116.668000000005},{"$f":"$D$6*1.074*(1+$C$9)","v":312723.50796000002},{"$f":"E43*(1+$C$9)/(1+$C$5)","v":332112.36545352003},352703.33211163827,374570.93870255986,397794.33690211858,422457.58579004992,448649.95610903302,476466.25338779308,506007.16109783627,537379.60508590215,570697.14060122811,606080.3633185043,643657.34584425157,683564.10128659522,725945.07556636422]
[null,"Lecturer development",{"$f":"C41*$D$12","v":20218658.73},{"$f":"D41*$D$12","v":21472215.571260002},15759950.38349002,18055611.849893194,20575354.088856231,23338138.593499687,26364416.715601377,29676241.520090263,33297387.782481,37253480.709004961,41572133.999782041,46283097.918770052,51418418.080617428,57012605.714134127,63102820.215104997,69729064.85783112,76934396.595348388]
[null,"Management and Support",{"$f":"$C$21*$C$20","v":242790317.52367812},{"$f":"$D$20*$D$21*(1+$C$9)/(1+$C$5)","v":275890077},{"$f":"D45*(1+$C$9)/(1+$C$5)","v":292995261.77399999},{"$f":"E45*(1+$C$9)/(1+$C$5)","v":311160968.00398803},{"$f":"F45*(1+$C$9)/(1+$C$5)","v":330452948.0202353},350941030.79748988,372699374.70693427,395806735.93876421,420346753.56696761,446408252.28811961,474085563.92998308,503478868.89364207,534694558.76504791,567845621.40848088,603052049.93580675,640441277.03182685,680148636.20780015]
[null,"Indirect costs per centre",{"$f":"$C$17+$C$18","v":21208.745421245425},{"$f":"($D$17+$D$18)*(1+$C$15)/(1+$C$5)","v":45610.776000000005},{"$f":"D46*(1+$C$15)/(1+$C$5)","v":48438.644112000009},{"$f":"E46*(1+$C$15)/(1+$C$5)","v":51441.840046944009},{"$f":"F46*(1+$C$15)/(1+$C$5)","v":54631.234129854543},{"$f":"G46*(1+$C$15)/(1+$C$5)","v":58018.370645905525},{"$f":"H46*(1+$C$15)/(1+$C$5)","v":61615.509625951672},{"$f":"I46*(1+$C$15)/(1+$C$5)","v":65435.671222760677},{"$f":"J46*(1+$C$15)/(1+$C$5)","v":69492.68283857184},{"$f":"K46*(1+$C$15)/(1+$C$5)","v":73801.229174563297},{"$f":"L46*(1+$C$15)/(1+$C$5)","v":78376.905383386227},{"$f":"M46*(1+$C$15)/(1+$C$5)","v":83236.27351715618},{"$f":"N46*(1+$C$15)/(1+$C$5)","v":88396.922475219864},{"$f":"O46*(1+$C$15)/(1+$C$5)","v":93877.531668683499},{"$f":"P46*(1+$C$15)/(1+$C$5)","v":99697.938632141886},{"$f":"Q46*(1+$C$15)/(1+$C$5)","v":105879.21082733468},{"$f":"R46*(1+$C$15)/(1+$C$5)","v":112443.72189862943}]
[null,"Total indirect costs",{"$f":"C46*$D$16","v":69479850.000000015},149420902.17600003,158684998.11091202,168523467.99378857,178971923.0094035,190068182.2359865,201852409.53461769,214367258.92576396,227658028.97916135,241772826.77586937,256762742.03597328,272682032.04220366,289588318.02882028,307542793.74660712,326610446.95889682,346860294.67034841,368365632.93990999,{"$f":"S51-S50","v":12380847603.402424}]
[null,"Direct cost per learner",525,{"$f":"$D$14*(1+$C$15)/(1+$C$5)","v":3823.2000000000003},{"$f":"D48*(1+$C$15)/(1+$C$5)","v":4060.2384000000006},{"$f":"E48*(1+$C$15)/(1+$C$5)","v":4311.9731808000006},{"$f":"F48*(1+$C$15)/(1+$C$5)","v":4579.315518009601},{"$f":"G48*(1+$C$15)/(1+$C$5)","v":4863.2330801261969},{"$f":"H48*(1+$C$15)/(1+$C$5)","v":5164.7535310940211},{"$f":"I48*(1+$C$15)/(1+$C$5)","v":5484.9682500218505},{"$f":"J48*(1+$C$15)/(1+$C$5)","v":5825.0362815232056},{"$f":"K48*(1+$C$15)/(1+$C$5)","v":6186.1885309776444},{"$f":"L48*(1+$C$15)/(1+$C$5)","v":6569.7322198982583},{"$f":"M48*(1+$C$15)/(1+$C$5)","v":6977.0556175319507},{"$f":"N48*(1+$C$15)/(1+$C$5)","v":7409.6330658189318},{"$f":"O48*(1+$C$15)/(1+$C$5)","v":7869.0303158997058},{"$f":"P48*(1+$C$15)/(1+$C$5)","v":8356.9101954854887},{"$f":"Q48*(1+$C$15)/(1+$C$5)","v":8875.0386276055888},{"$f":"R48*(1+$C$15)/(1+$C$5)","v":9425.2910225171363},{"$f":"T47/SUM(Enrolments!S99:S103)","v":20481.137474611121}]
[null,"Total direct cost",{"$f":"C48*C52","v":133877620.27500001},{"$f":"D48*D52","v":1088632526.7456002},1254996224.5102389,1437804317.3648825,1638456408.2464852,1858462438.6014555,2099450990.287143,2363178192.7678719,2651537278.7495475,2966568834.419951,3310471793.6939712,3685615229.31846,4094550997.3854256,4540027295.751195,5025003201.0803699,5552664253.7454948,6126439164.6361389]
[null,"Total occupational Costs",{"$f":"Enrolments!$G$84*Enrolments!C104","v":114240135},{"$f":"(Enrolments!$G$84*Enrolments!D104)*(1+$C$15)/(1+$C$5)","v":135471778.56000003},{"$f":"(Enrolments!$G$84*Enrolments!E104)*(1+$C$15)/(1+$C$5)","v":498140326.65600002},{"$f":"(Enrolments!$G$84*Enrolments!F104)*(1+$C$15)/(1+$C$5)","v":860808874.75200021},{"$f":"(Enrolments!$G$84*Enrolments!G104)*(1+$C$15)/(1+$C$5)","v":1223477422.8480003},{"$f":"(Enrolments!$G$84*Enrolments!H104)*(1+$C$15)/(1+$C$5)","v":1586145970.944},{"$f":"(Enrolments!$G$84*Enrolments!I104)*(1+$C$15)/(1+$C$5)","v":1948814519.0400002},{"$f":"(Enrolments!$G$84*Enrolments!J104)*(1+$C$15)/(1+$C$5)","v":2311483067.1360002},{"$f":"(Enrolments!$G$84*Enrolments!K104)*(1+$C$15)/(1+$C$5)","v":2674151615.2320004},{"$f":"(Enrolments!$G$84*Enrolments!L104)*(1+$C$15)/(1+$C$5)","v":3036820163.3280001},{"$f":"(Enrolments!$G$84*Enrolments!M104)*(1+$C$15)/(1+$C$5)","v":3399488711.4240003},{"$f":"(Enrolments!$G$84*Enrolments!N104)*(1+$C$15)/(1+$C$5)","v":3762157259.52},{"$f":"(Enrolments!$G$84*Enrolments!O104)*(1+$C$15)/(1+$C$5)","v":4124825807.6160002},{"$f":"(Enrolments!$G$84*Enrolments!P104)*(1+$C$15)/(1+$C$5)","v":4487494355.7120008},{"$f":"(Enrolments!$G$84*Enrolments!Q104)*(1+$C$15)/(1+$C$5)","v":4850162903.8080006},{"$f":"(Enrolments!$G$84*Enrolments!R104)*(1+$C$15)/(1+$C$5)","v":5212831451.9040003},{"$f":"(Enrolments!$G$84*Enrolments!S104)*(1+$C$15)/(1+$C$5)","v":5575500000}]
[null,"Total costs",{"$f":"C49+C47+C45+C44+C41+C50","v":1928517163.5286782},3102368538.1368604,3271240120.3339758,4000060696.6240988,4763624328.8033962,5564831667.4057436,6406809491.3243885,7292927597.6278419,8226816916.4755573,9212388938.1212769,10253856545.06918,11355756348.944412,12522972638.58374,13760763053.274693,15074786103.005178,16471130666.064911,17956347603.402424,{"$f":"SUM(C51:S51)","v":151165198416.72635}]
["Full White Paper",{"$f":"Enrolments!B18:S18","v":"Total Enrolment"},{"$f":"Enrolments!C64","v":255004.99100000001},{"$f":"Enrolments!D64","v":284743.80800000002},{"$f":"Enrolments!E64","v":309094.22080000001},{"$f":"Enrolments!F64","v":333444.63359999994},{"$f":"Enrolments!G64","v":357795.04639999999},{"$f":"Enrolments!H64","v":382145.45919999992},{"$f":"Enrolments!I64","v":406495.87199999997},{"$f":"Enrolments!J64","v":430846.28480000002},{"$f":"Enrolments!K64","v":455196.69760000007},{"$f":"Enrolments!L64","v":479547.11040000012},{"$f":"Enrolments!M64","v":503897.52320000017},{"$f":"Enrolments!N64","v":528247.93600000022},{"$f":"Enrolments!O64","v":552598.34880000027},{"$f":"Enrolments!P64","v":576948.76160000032},{"$f":"Enrolments!Q64","v":601299.17440000037},{"$f":"Enrolments!R64","v":625649.58720000042},{"$f":"Enrolments!S64","v":650000}]
[null,"Lecturing costs",{"$f":"$C7*$C6","v":1347910582},{"$f":"D54*D55","v":1431481038.0840001},{"$f":"E54*E55","v":1001026432.6268398},1101480620.3208377,1216244968.0295663,1347471750.1686046,1497627475.057694,1669537291.423228,1866435530.9908674,2092023223.5576885,2350533534.0475469,2646806199.3987718,2986372188.7560196,3375549975.6586509,3821554998.36836,4332624097.1438742,4438522880.5008688]
[null,"Lecturers required",{"$f":"$C$7","v":16063},{"$f":"C54","v":16063},{"$f":"E64/Expenditure!$D$8/$D$10","v":3200.9951511380445},{"$f":"F64/Expenditure!$D$8/$D$10","v":3316.5902113180809},{"$f":"G64/Expenditure!$D$8/$D$10","v":3448.3512269302814},{"$f":"H64/Expenditure!$D$8/$D$10","v":3597.3739843138446},{"$f":"I64/Expenditure!$D$8/$D$10","v":3764.8285461293549},{"$f":"J64/Expenditure!$D$8/$D$10","v":3951.9642860737818},{"$f":"K64/Expenditure!$D$8/$D$10","v":4160.1152648664865},{"$f":"L64/Expenditure!$D$8/$D$10","v":4390.7059706388127},{"$f":"M64/Expenditure!$D$8/$D$10","v":4645.2574484278339},{"$f":"N64/Expenditure!$D$8/$D$10","v":4925.3938451491285},{"$f":"O64/Expenditure!$D$8/$D$10","v":5232.8493982112532},{"$f":"P64/Expenditure!$D$8/$D$10","v":5569.4758978435157},{"$f":"Q64/Expenditure!$D$8/$D$10","v":5937.2506552470504},{"$f":"R64/Expenditure!$D$8/$D$10","v":6338.2850108557004},{"$f":"S64/Expenditure!$D$8/$D$10","v":6114.130434782609}]
[null,"Average lecturer salary",{"$f":"$C$6","v":83914},{"$f":"C55*(1+$C$9)/(1+$C$5)","v":89116.668000000005},{"$f":"$E$6*1.074*(1+$C$9)","v":312723.50796000002},{"$f":"E55*(1+$C$9)/(1+$C$5)","v":332112.36545352003},{"$f":"F55*(1+$C$9)/(1+$C$5)","v":352703.33211163827},374570.93870255986,397794.33690211858,422457.58579004992,448649.95610903302,476466.25338779308,506007.16109783627,537379.60508590215,570697.14060122811,606080.3633185043,643657.34584425157,683564.10128659522,725945.07556636422]
[null,"Lecturer development",{"$f":"C53*$C$12","v":14827016.401999999},{"$f":"D53*$E$12","v":21472215.571260002},{"$f":"E53*$E$12","v":15015396.489402596},16522209.304812565,18243674.520443495,20212076.25252907,22464412.125865407,25043059.371348418,27996532.96486301,31380348.353365324,35258003.010713205,39702092.990981571,44795582.831340291,50633249.63487976,57323324.975525402,64989361.457158111,66577843.207513027]
[null,"Management and Support",{"$f":"$C$21*$C$20","v":242790317.52367812},{"$f":"$E$20*$E$21*(1+$C$9)/(1+$C$5)","v":275890077},{"$f":"D57*(1+$C$9)/(1+$C$5)","v":292995261.77399999},{"$f":"E57*(1+$C$9)/(1+$C$5)","v":311160968.00398803},330452948.0202353,350941030.79748988,372699374.70693427,395806735.93876421,420346753.56696761,446408252.28811961,474085563.92998308,503478868.89364207,534694558.76504791,567845621.40848088,603052049.93580675,640441277.03182685,680148636.20780015]
[null,"Indirect costs per centre",{"$f":"$C$17+$C$18","v":21208.745421245425},{"$f":"($E$17+$E$18)*(1+$C$9)/(1+$C$5)","v":34990.776000000005},{"$f":"D58*(1+$C$9)/(1+$C$5)","v":37160.204112000007},{"$f":"E58*(1+$C$9)/(1+$C$5)","v":39464.136766944008},41910.913246494536,44509.389867777201,47268.972039579392,50199.648306033319,53312.026501007385,56617.372144069843,60127.649217002174,63855.563468456312,67814.608403500606,72019.11412451764,76484.299200237743,81226.325750652482,86262.357947192941]
[null,"Total indirect costs",{"$f":"C58*$E$16","v":69479850.000000015},{"$f":"D58*$E$16","v":114629782.17600001},121736828.67091203,129284512.04850857,137300151.7955161,145812761.2068381,154853152.40166208,164454047.85056517,174650198.8173002,185478511.14397281,196978178.83489913,209190825.92266288,222160657.12986797,235934617.87191978,250562564.17997885,266097443.15913755,282595484.6350041]
[null,"Direct cost per learner",525,{"$f":"$E$14*(1+$C$15)/(1+$C$5)","v":2761.2000000000003},{"$f":"D60*(1+$C$15)/(1+$C$5)","v":2932.3944000000006},{"$f":"E60*(1+$C$15)/(1+$C$5)","v":3114.202852800001},{"$f":"F60*(1+$C$15)/(1+$C$5)","v":3307.2834296736014},{"$f":"G60*(1+$C$15)/(1+$C$5)","v":3512.3350023133648},{"$f":"H60*(1+$C$15)/(1+$C$5)","v":3730.0997724567937},{"$f":"I60*(1+$C$15)/(1+$C$5)","v":3961.3659583491153},{"$f":"J60*(1+$C$15)/(1+$C$5)","v":4206.9706477667605},{"$f":"K60*(1+$C$15)/(1+$C$5)","v":4467.8028279282998},{"$f":"L60*(1+$C$15)/(1+$C$5)","v":4744.8066032598545},{"$f":"M60*(1+$C$15)/(1+$C$5)","v":5038.9846126619659},{"$f":"N60*(1+$C$15)/(1+$C$5)","v":5351.4016586470079},{"$f":"O60*(1+$C$15)/(1+$C$5)","v":5683.1885614831226},{"$f":"P60*(1+$C$15)/(1+$C$5)","v":6035.5462522950766},{"$f":"Q60*(1+$C$15)/(1+$C$5)","v":6409.7501199373719},{"$f":"R60*(1+$C$15)/(1+$C$5)","v":6807.1546273734893}]
[null,"Total direct cost",{"$f":"C60*C64","v":134414577.34282005},760291155.68749058,863565383.51744092,950225192.18428993,1049230088.271946,1162436795.6595645,1291973121.4995472,1440276264.8147011,1610136418.5770171,1804746386.8044019,2027758035.7931018,2283346509.3245902,2576283263.3114681,2912019117.8793793,3296778686.5915794,3737667725.9847207,3829024477.8975878]
[null,"Total occupational Costs",{"$f":"Enrolments!$G$84*Enrolments!C112","v":98898504.490855977},{"$f":"Enrolments!$G$84*Enrolments!D112*(1+$C$15)/(1+$C$5)","v":285145511.03370851},{"$f":"Enrolments!$G$84*Enrolments!E112*(1+$C$15)/(1+$C$5)","v":465260810.29812801},{"$f":"Enrolments!$G$84*Enrolments!F112*(1+$C$15)/(1+$C$5)","v":645376109.56254745},{"$f":"Enrolments!$G$84*Enrolments!G112*(1+$C$15)/(1+$C$5)","v":825491408.82696676},{"$f":"Enrolments!$G$84*Enrolments!H112*(1+$C$15)/(1+$C$5)","v":1005606708.0913862},{"$f":"Enrolments!$G$84*Enrolments!I112*(1+$C$15)/(1+$C$5)","v":1185722007.3558056},{"$f":"Enrolments!$G$84*Enrolments!J112*(1+$C$15)/(1+$C$5)","v":1365837306.6202247},{"$f":"Enrolments!$G$84*Enrolments!K112*(1+$C$15)/(1+$C$5)","v":1545952605.8846443},{"$f":"Enrolments!$G$84*Enrolments!L112*(1+$C$15)/(1+$C$5)","v":1726067905.1490638},{"$f":"Enrolments!$G$84*Enrolments!M112*(1+$C$15)/(1+$C$5)","v":1906183204.4134831},{"$f":"Enrolments!$G$84*Enrolments!N112*(1+$C$15)/(1+$C$5)","v":2086298503.6779025},{"$f":"Enrolments!$G$84*Enrolments!O112*(1+$C$15)/(1+$C$5)","v":2266413802.9423218},{"$f":"Enrolments!$G$84*Enrolments!P112*(1+$C$15)/(1+$C$5)","v":2446529102.2067413},{"$f":"Enrolments!$G$84*Enrolments!Q112*(1+$C$15)/(1+$C$5)","v":2626644401.4711604},{"$f":"Enrolments!$G$84*Enrolments!R112*(1+$C$15)/(1+$C$5)","v":2806759700.73558},{"$f":"Enrolments!$G$84*Enrolments!S112*(1+$C$15)/(1+$C$5)","v":2986875000}]
[null,"Total costs",{"$f":"C61+C59+C57+C56+C53+C62","v":1908320847.7593541},2888909779.5524592,2759600113.3767233,3154049611.4249849,3576963239.4646735,4032481122.1764126,4525339543.1475086,5060954706.0188322,5645518040.8016596,6286104627.2966127,6990796520.029726,7768823000.2085505,8630720053.7360649,9588511684.6600513,10655916025.522411,11848579605.512299,12283744322.448772,{"$f":"SUM(C63:S63)","v":107605332843.1371}]
["Balanced",{"$f":"Enrolments!B26","v":"Total Enrolment"},{"$f":"Enrolments!C65","v":256027.76636727626},{"$f":"Enrolments!D65","v":275348.09346932149},{"$f":"Enrolments!E65","v":294491.55390470009},{"$f":"Enrolments!F65","v":305126.29944126343},{"$f":"Enrolments!G65","v":317248.31287758588},{"$f":"Enrolments!H65","v":330958.4065568737},{"$f":"Enrolments!I65","v":346364.22624390066},{"$f":"Enrolments!J65","v":363580.71431878791},{"$f":"Enrolments!K65","v":382730.60436771676},{"$f":"Enrolments!L65","v":403944.94929877081},{"$f":"Enrolments!M65","v":427363.68525536073},{"$f":"Enrolments!N65","v":453136.23375371983},{"$f":"Enrolments!O65","v":481422.14463543525},{"$f":"Enrolments!P65","v":512391.78260160342},{"$f":"Enrolments!Q65","v":546227.06028272863},{"$f":"Enrolments!R65","v":583122.22099872446},{"$f":"Enrolments!S65","v":562500}]
[]
[]
[]
[null,"Total costs",2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"Status Quo (R'm)",{"$f":"C39/1000000","v":1843.8189689996782},1999.6353404988181,2398.482007948995,2836.9207654669972,3318.4115362424368,3846.6910819462196,4425.794030757479,5060.0754486987362,5754.2350648177662,6513.3432685289235,7342.8690057401527,8248.7097092812783,9237.2234086542485,10315.263174288681,11490.21406235149,12770.032737775569,14163.289965590888]
[null,"Full White Paper (R'm)",{"$f":"C51/1000000","v":1928.5171635286781},3102.3685381368605,3271.2401203339759,4000.0606966240989,4763.6243288033966,5564.8316674057432,6406.8094913243885,7292.9275976278423,8226.8169164755582,9212.3889381212775,10253.85654506918,11355.756348944413,12522.97263858374,13760.763053274692,15074.786103005179,16471.13066606491,17956.347603402424]
[null,"Balanced (R'm)",{"$f":"C63/1000000","v":1908.3208477593541},{"$f":"D63/1000000","v":2888.9097795524594},2759.6001133767231,3154.049611424985,3576.9632394646737,4032.4811221764126,4525.3395431475083,5060.9547060188324,5645.5180408016595,6286.1046272966123,6990.7965200297258,7768.8230002085502,8630.7200537360641,9588.5116846600522,10655.916025522411,11848.579605512299,12283.744322448772]

{"sheet":"Learner Numbers","index":3,"n_rows":78,"n_cols":19,"rows_kept":78,"cut":false,"hidden":true,"merged":[[20,0,31,0],[34,0,45,0]]}
[]
[null,null,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[]
[]
[]
[]
[]
[]
[]
[null,"Enrolment","Potential Key Variable A"]
["Number of enrolments per learning intervention",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"AET Level 1",{"$f":"ROUNDUP(C$11*C63,0)","v":{"$error":"#REF!"}},{"$f":"ROUNDUP(D$11*D63,0)","v":{"$error":"#REF!"}},{"$f":"ROUNDUP(E$11*E63,0)","v":{"$error":"#REF!"}},{"$f":"Enrolments!C11","v":{"$error":"#REF!"}},{"$f":"ROUNDUP(G$11*G63,0)","v":{"$error":"#REF!"}},{"$f":"Enrolments!D11","v":{"$error":"#REF!"}},{"$f":"ROUNDUP(I$11*I63,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"AET Level 2",{"$f":"ROUNDUP(C$11*C64,0)","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"Enrolments!D12","v":{"$error":"#REF!"}}]
[null,"AET Level 3",{"$f":"ROUNDUP(C$11*C65,0)","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"Enrolments!D13","v":{"$error":"#REF!"}}]
[null,"AET Level 4",{"$f":"ROUNDUP(C$11*C66,0)","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"Enrolments!D14","v":{"$error":"#REF!"}}]
[null,"Grade 12",{"$f":"ROUNDUP(C$11*C67,0)","v":{"$error":"#REF!"}},{"$f":"ROUNDUP(D$11*D67,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"Enrolments!D15","v":{"$error":"#REF!"}},{"$f":"ROUNDUP(I$11*I67,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Occupational Programmes",{"$f":"ROUNDUP(C$11*C68,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"Enrolments!D16","v":{"$error":"#REF!"}},{"$f":"ROUNDUP(I$11*I68,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[]
[]
["Number of dropouts per learning intervention",{"$f":"Dashboard!N4","v":"Status quo"},{"$f":"SUM(C22:C24)","v":141121},{"$f":"SUM(D22:D24)","v":157579},{"$f":"SUM(E22:E24)","v":182897},208215,233534,258852,284171,309489,{"$f":"SUM(K22:K24)","v":334807},360126,385444,410762,436080,461399,486716,512035,537353]
[null,"AET Level 1 to 4",{"$f":"ROUNDUP((SUM(Enrolments!C3:C6))*'Enrol Scenarios'!$B$18,0)","v":99303},{"$f":"ROUNDUP((SUM(Enrolments!D3:D6))*'Enrol Scenarios'!$B$18,0)","v":110884},{"$f":"ROUNDUP((SUM(Enrolments!E3:E6))*'Enrol Scenarios'!$B$18,0)","v":128700},{"$f":"ROUNDUP((SUM(Enrolments!F3:F6))*'Enrol Scenarios'!$B$18,0)","v":146516},{"$f":"ROUNDUP((SUM(Enrolments!G3:G6))*'Enrol Scenarios'!$B$18,0)","v":164332},{"$f":"ROUNDUP((SUM(Enrolments!H3:H6))*'Enrol Scenarios'!$B$18,0)","v":182148},{"$f":"ROUNDUP((SUM(Enrolments!I3:I6))*'Enrol Scenarios'!$B$18,0)","v":199964},{"$f":"ROUNDUP((SUM(Enrolments!J3:J6))*'Enrol Scenarios'!$B$18,0)","v":217780},{"$f":"ROUNDUP((SUM(Enrolments!K3:K6))*'Enrol Scenarios'!$B$18,0)","v":235596},{"$f":"ROUNDUP((SUM(Enrolments!L3:L6))*'Enrol Scenarios'!$B$18,0)","v":253412},{"$f":"ROUNDUP((SUM(Enrolments!M3:M6))*'Enrol Scenarios'!$B$18,0)","v":271228},{"$f":"ROUNDUP((SUM(Enrolments!N3:N6))*'Enrol Scenarios'!$B$18,0)","v":289044},{"$f":"ROUNDUP((SUM(Enrolments!O3:O6))*'Enrol Scenarios'!$B$18,0)","v":306859},{"$f":"ROUNDUP((SUM(Enrolments!P3:P6))*'Enrol Scenarios'!$B$18,0)","v":324675},{"$f":"ROUNDUP((SUM(Enrolments!Q3:Q6))*'Enrol Scenarios'!$B$18,0)","v":342491},{"$f":"ROUNDUP((SUM(Enrolments!R3:R6))*'Enrol Scenarios'!$B$18,0)","v":360307},{"$f":"ROUNDUP((SUM(Enrolments!S3:S6))*'Enrol Scenarios'!$B$18,0)","v":378123}]
[null,"Grade 12",{"$f":"ROUNDUP(Enrolments!C7*'Enrol Scenarios'!$B$19,0)","v":41513},{"$f":"ROUNDUP(Enrolments!D7*'Enrol Scenarios'!$B$19,0)","v":46354},{"$f":"ROUNDUP(Enrolments!E7*'Enrol Scenarios'!$B$19,0)","v":53802},{"$f":"ROUNDUP(Enrolments!F7*'Enrol Scenarios'!$B$19,0)","v":61249},{"$f":"ROUNDUP(Enrolments!G7*'Enrol Scenarios'!$B$19,0)","v":68697},{"$f":"ROUNDUP(Enrolments!H7*'Enrol Scenarios'!$B$19,0)","v":76145},{"$f":"ROUNDUP(Enrolments!I7*'Enrol Scenarios'!$B$19,0)","v":83593},{"$f":"ROUNDUP(Enrolments!J7*'Enrol Scenarios'!$B$19,0)","v":91040},{"$f":"ROUNDUP(Enrolments!K7*'Enrol Scenarios'!$B$19,0)","v":98488},{"$f":"ROUNDUP(Enrolments!L7*'Enrol Scenarios'!$B$19,0)","v":105936},{"$f":"ROUNDUP(Enrolments!M7*'Enrol Scenarios'!$B$19,0)","v":113383},{"$f":"ROUNDUP(Enrolments!N7*'Enrol Scenarios'!$B$19,0)","v":120831},{"$f":"ROUNDUP(Enrolments!O7*'Enrol Scenarios'!$B$19,0)","v":128279},{"$f":"ROUNDUP(Enrolments!P7*'Enrol Scenarios'!$B$19,0)","v":135727},{"$f":"ROUNDUP(Enrolments!Q7*'Enrol Scenarios'!$B$19,0)","v":143174},{"$f":"ROUNDUP(Enrolments!R7*'Enrol Scenarios'!$B$19,0)","v":150622},{"$f":"ROUNDUP(Enrolments!S7*'Enrol Scenarios'!$B$19,0)","v":158070}]
[null,"Occupational Programmes",{"$f":"ROUNDUP(Enrolments!C8*'Enrol Scenarios'!$B$20,0)","v":305},{"$f":"ROUNDUP(Enrolments!D8*'Enrol Scenarios'!$B$20,0)","v":341},{"$f":"ROUNDUP(Enrolments!E8*'Enrol Scenarios'!$B$20,0)","v":395},{"$f":"ROUNDUP(Enrolments!F8*'Enrol Scenarios'!$B$20,0)","v":450},{"$f":"ROUNDUP(Enrolments!G8*'Enrol Scenarios'!$B$20,0)","v":505},{"$f":"ROUNDUP(Enrolments!H8*'Enrol Scenarios'!$B$20,0)","v":559},{"$f":"ROUNDUP(Enrolments!I8*'Enrol Scenarios'!$B$20,0)","v":614},{"$f":"ROUNDUP(Enrolments!J8*'Enrol Scenarios'!$B$20,0)","v":669},{"$f":"ROUNDUP(Enrolments!K8*'Enrol Scenarios'!$B$20,0)","v":723},{"$f":"ROUNDUP(Enrolments!L8*'Enrol Scenarios'!$B$20,0)","v":778},{"$f":"ROUNDUP(Enrolments!M8*'Enrol Scenarios'!$B$20,0)","v":833},{"$f":"ROUNDUP(Enrolments!N8*'Enrol Scenarios'!$B$20,0)","v":887},{"$f":"ROUNDUP(Enrolments!O8*'Enrol Scenarios'!$B$20,0)","v":942},{"$f":"ROUNDUP(Enrolments!P8*'Enrol Scenarios'!$B$20,0)","v":997},{"$f":"ROUNDUP(Enrolments!Q8*'Enrol Scenarios'!$B$20,0)","v":1051},{"$f":"ROUNDUP(Enrolments!R8*'Enrol Scenarios'!$B$20,0)","v":1106},{"$f":"ROUNDUP(Enrolments!S8*'Enrol Scenarios'!$B$20,0)","v":1160}]
[null,{"$f":"Dashboard!O4","v":"Full Policy"},{"$f":"SUM(C26:C28)","v":141121},157579,171840,186102,200363,214624,228887,243149,{"$f":"SUM(K26:K28)","v":257409},271671,285933,300194,314455,328717,342978,357240,371500]
[null,"AET Level 1 to 4",{"$f":"ROUNDUP((SUM(Enrolments!C19:C22))*'Enrol Scenarios'!$C$18,0)","v":99303},{"$f":"ROUNDUP((SUM(Enrolments!D19:D22))*'Enrol Scenarios'!$C$18,0)","v":110884},{"$f":"ROUNDUP((SUM(Enrolments!E19:E22))*'Enrol Scenarios'!$C$18,0)","v":121092},{"$f":"ROUNDUP((SUM(Enrolments!F19:F22))*'Enrol Scenarios'!$C$18,0)","v":131300},{"$f":"ROUNDUP((SUM(Enrolments!G19:G22))*'Enrol Scenarios'!$C$18,0)","v":141507},{"$f":"ROUNDUP((SUM(Enrolments!H19:H22))*'Enrol Scenarios'!$C$18,0)","v":151715},{"$f":"ROUNDUP((SUM(Enrolments!I19:I22))*'Enrol Scenarios'!$C$18,0)","v":161923},{"$f":"ROUNDUP((SUM(Enrolments!J19:J22))*'Enrol Scenarios'!$C$18,0)","v":172131},{"$f":"ROUNDUP((SUM(Enrolments!K19:K22))*'Enrol Scenarios'!$C$18,0)","v":182338},{"$f":"ROUNDUP((SUM(Enrolments!L19:L22))*'Enrol Scenarios'!$C$18,0)","v":192546},{"$f":"ROUNDUP((SUM(Enrolments!M19:M22))*'Enrol Scenarios'!$C$18,0)","v":202754},{"$f":"ROUNDUP((SUM(Enrolments!N19:N22))*'Enrol Scenarios'!$C$18,0)","v":212962},{"$f":"ROUNDUP((SUM(Enrolments!O19:O22))*'Enrol Scenarios'!$C$18,0)","v":223169},{"$f":"ROUNDUP((SUM(Enrolments!P19:P22))*'Enrol Scenarios'!$C$18,0)","v":233377},{"$f":"ROUNDUP((SUM(Enrolments!Q19:Q22))*'Enrol Scenarios'!$C$18,0)","v":243585},{"$f":"ROUNDUP((SUM(Enrolments!R19:R22))*'Enrol Scenarios'!$C$18,0)","v":253793},{"$f":"ROUNDUP((SUM(Enrolments!S19:S22))*'Enrol Scenarios'!$C$18,0)","v":264000}]
[null,"Grade 12",{"$f":"ROUNDUP(Enrolments!C23*'Enrol Scenarios'!$C$19,0)","v":41513},{"$f":"ROUNDUP(Enrolments!D23*'Enrol Scenarios'!$C$19,0)","v":46354},{"$f":"ROUNDUP(Enrolments!E23*'Enrol Scenarios'!$C$19,0)","v":49497},{"$f":"ROUNDUP(Enrolments!F23*'Enrol Scenarios'!$C$19,0)","v":52640},{"$f":"ROUNDUP(Enrolments!G23*'Enrol Scenarios'!$C$19,0)","v":55783},{"$f":"ROUNDUP(Enrolments!H23*'Enrol Scenarios'!$C$19,0)","v":58926},{"$f":"ROUNDUP(Enrolments!I23*'Enrol Scenarios'!$C$19,0)","v":62070},{"$f":"ROUNDUP(Enrolments!J23*'Enrol Scenarios'!$C$19,0)","v":65213},{"$f":"ROUNDUP(Enrolments!K23*'Enrol Scenarios'!$C$19,0)","v":68356},{"$f":"ROUNDUP(Enrolments!L23*'Enrol Scenarios'!$C$19,0)","v":71499},{"$f":"ROUNDUP(Enrolments!M23*'Enrol Scenarios'!$C$19,0)","v":74642},{"$f":"ROUNDUP(Enrolments!N23*'Enrol Scenarios'!$C$19,0)","v":77785},{"$f":"ROUNDUP(Enrolments!O23*'Enrol Scenarios'!$C$19,0)","v":80928},{"$f":"ROUNDUP(Enrolments!P23*'Enrol Scenarios'!$C$19,0)","v":84071},{"$f":"ROUNDUP(Enrolments!Q23*'Enrol Scenarios'!$C$19,0)","v":87214},{"$f":"ROUNDUP(Enrolments!R23*'Enrol Scenarios'!$C$19,0)","v":90357},{"$f":"ROUNDUP(Enrolments!S23*'Enrol Scenarios'!$C$19,0)","v":93500}]
[null,"Occupational Programmes",{"$f":"ROUNDUP(Enrolments!C24*'Enrol Scenarios'!$C$20,0)","v":305},{"$f":"ROUNDUP(Enrolments!D24*'Enrol Scenarios'!$C$20,0)","v":341},{"$f":"ROUNDUP(Enrolments!E24*'Enrol Scenarios'!$C$20,0)","v":1251},{"$f":"ROUNDUP(Enrolments!F24*'Enrol Scenarios'!$C$20,0)","v":2162},{"$f":"ROUNDUP(Enrolments!G24*'Enrol Scenarios'!$C$20,0)","v":3073},{"$f":"ROUNDUP(Enrolments!H24*'Enrol Scenarios'!$C$20,0)","v":3983},{"$f":"ROUNDUP(Enrolments!I24*'Enrol Scenarios'!$C$20,0)","v":4894},{"$f":"ROUNDUP(Enrolments!J24*'Enrol Scenarios'!$C$20,0)","v":5805},{"$f":"ROUNDUP(Enrolments!K24*'Enrol Scenarios'!$C$20,0)","v":6715},{"$f":"ROUNDUP(Enrolments!L24*'Enrol Scenarios'!$C$20,0)","v":7626},{"$f":"ROUNDUP(Enrolments!M24*'Enrol Scenarios'!$C$20,0)","v":8537},{"$f":"ROUNDUP(Enrolments!N24*'Enrol Scenarios'!$C$20,0)","v":9447},{"$f":"ROUNDUP(Enrolments!O24*'Enrol Scenarios'!$C$20,0)","v":10358},{"$f":"ROUNDUP(Enrolments!P24*'Enrol Scenarios'!$C$20,0)","v":11269},{"$f":"ROUNDUP(Enrolments!Q24*'Enrol Scenarios'!$C$20,0)","v":12179},{"$f":"ROUNDUP(Enrolments!R24*'Enrol Scenarios'!$C$20,0)","v":13090},{"$f":"ROUNDUP(Enrolments!S24*'Enrol Scenarios'!$C$20,0)","v":14000}]
[null,{"$f":"Dashboard!P4","v":"Mixed"},{"$f":"SUM(C30:C32)","v":141080},152068,163055,174042,185030,196017,207004,217991,{"$f":"SUM(K30:K32)","v":228979},239966,250953,261940,272927,283915,294902,305889,316876]
[null,"AET Level 1 to 4",{"$f":"ROUNDUP((SUM(Enrolments!C27:C30))*'Enrol Scenarios'!$D$18,0)","v":99303},{"$f":"ROUNDUP((SUM(Enrolments!D27:D30))*'Enrol Scenarios'!$D$18,0)","v":106733},{"$f":"ROUNDUP((SUM(Enrolments!E27:E30))*'Enrol Scenarios'!$D$18,0)","v":114162},{"$f":"ROUNDUP((SUM(Enrolments!F27:F30))*'Enrol Scenarios'!$D$18,0)","v":121591},{"$f":"ROUNDUP((SUM(Enrolments!G27:G30))*'Enrol Scenarios'!$D$18,0)","v":129021},{"$f":"ROUNDUP((SUM(Enrolments!H27:H30))*'Enrol Scenarios'!$D$18,0)","v":136450},{"$f":"ROUNDUP((SUM(Enrolments!I27:I30))*'Enrol Scenarios'!$D$18,0)","v":143879},{"$f":"ROUNDUP((SUM(Enrolments!J27:J30))*'Enrol Scenarios'!$D$18,0)","v":151308},{"$f":"ROUNDUP((SUM(Enrolments!K27:K30))*'Enrol Scenarios'!$D$18,0)","v":158738},{"$f":"ROUNDUP((SUM(Enrolments!L27:L30))*'Enrol Scenarios'!$D$18,0)","v":166167},{"$f":"ROUNDUP((SUM(Enrolments!M27:M30))*'Enrol Scenarios'!$D$18,0)","v":173596},{"$f":"ROUNDUP((SUM(Enrolments!N27:N30))*'Enrol Scenarios'!$D$18,0)","v":181025},{"$f":"ROUNDUP((SUM(Enrolments!O27:O30))*'Enrol Scenarios'!$D$18,0)","v":188455},{"$f":"ROUNDUP((SUM(Enrolments!P27:P30))*'Enrol Scenarios'!$D$18,0)","v":195884},{"$f":"ROUNDUP((SUM(Enrolments!Q27:Q30))*'Enrol Scenarios'!$D$18,0)","v":203313},{"$f":"ROUNDUP((SUM(Enrolments!R27:R30))*'Enrol Scenarios'!$D$18,0)","v":210743},{"$f":"ROUNDUP((SUM(Enrolments!S27:S30))*'Enrol Scenarios'!$D$18,0)","v":218172}]
[null,"Grade 12",{"$f":"ROUNDUP(Enrolments!C31*'Enrol Scenarios'!$D$19,0)","v":41513},{"$f":"ROUNDUP(Enrolments!D31*'Enrol Scenarios'!$D$19,0)","v":44619},{"$f":"ROUNDUP(Enrolments!E31*'Enrol Scenarios'!$D$19,0)","v":47724},{"$f":"ROUNDUP(Enrolments!F31*'Enrol Scenarios'!$D$19,0)","v":50830},{"$f":"ROUNDUP(Enrolments!G31*'Enrol Scenarios'!$D$19,0)","v":53936},{"$f":"ROUNDUP(Enrolments!H31*'Enrol Scenarios'!$D$19,0)","v":57041},{"$f":"ROUNDUP(Enrolments!I31*'Enrol Scenarios'!$D$19,0)","v":60147},{"$f":"ROUNDUP(Enrolments!J31*'Enrol Scenarios'!$D$19,0)","v":63253},{"$f":"ROUNDUP(Enrolments!K31*'Enrol Scenarios'!$D$19,0)","v":66359},{"$f":"ROUNDUP(Enrolments!L31*'Enrol Scenarios'!$D$19,0)","v":69464},{"$f":"ROUNDUP(Enrolments!M31*'Enrol Scenarios'!$D$19,0)","v":72570},{"$f":"ROUNDUP(Enrolments!N31*'Enrol Scenarios'!$D$19,0)","v":75676},{"$f":"ROUNDUP(Enrolments!O31*'Enrol Scenarios'!$D$19,0)","v":78781},{"$f":"ROUNDUP(Enrolments!P31*'Enrol Scenarios'!$D$19,0)","v":81887},{"$f":"ROUNDUP(Enrolments!Q31*'Enrol Scenarios'!$D$19,0)","v":84993},{"$f":"ROUNDUP(Enrolments!R31*'Enrol Scenarios'!$D$19,0)","v":88098},{"$f":"ROUNDUP(Enrolments!S31*'Enrol Scenarios'!$D$19,0)","v":91204}]
[null,"Occupational Programmes",{"$f":"ROUNDUP(Enrolments!C32*'Enrol Scenarios'!$D$20,0)","v":264},{"$f":"ROUNDUP(Enrolments!D32*'Enrol Scenarios'!$D$20,0)","v":716},{"$f":"ROUNDUP(Enrolments!E32*'Enrol Scenarios'!$D$20,0)","v":1169},{"$f":"ROUNDUP(Enrolments!F32*'Enrol Scenarios'!$D$20,0)","v":1621},{"$f":"ROUNDUP(Enrolments!G32*'Enrol Scenarios'!$D$20,0)","v":2073},{"$f":"ROUNDUP(Enrolments!H32*'Enrol Scenarios'!$D$20,0)","v":2526},{"$f":"ROUNDUP(Enrolments!I32*'Enrol Scenarios'!$D$20,0)","v":2978},{"$f":"ROUNDUP(Enrolments!J32*'Enrol Scenarios'!$D$20,0)","v":3430},{"$f":"ROUNDUP(Enrolments!K32*'Enrol Scenarios'!$D$20,0)","v":3882},{"$f":"ROUNDUP(Enrolments!L32*'Enrol Scenarios'!$D$20,0)","v":4335},{"$f":"ROUNDUP(Enrolments!M32*'Enrol Scenarios'!$D$20,0)","v":4787},{"$f":"ROUNDUP(Enrolments!N32*'Enrol Scenarios'!$D$20,0)","v":5239},{"$f":"ROUNDUP(Enrolments!O32*'Enrol Scenarios'!$D$20,0)","v":5691},{"$f":"ROUNDUP(Enrolments!P32*'Enrol Scenarios'!$D$20,0)","v":6144},{"$f":"ROUNDUP(Enrolments!Q32*'Enrol Scenarios'!$D$20,0)","v":6596},{"$f":"ROUNDUP(Enrolments!R32*'Enrol Scenarios'!$D$20,0)","v":7048},{"$f":"ROUNDUP(Enrolments!S32*'Enrol Scenarios'!$D$20,0)","v":7500}]
[]
[]
["Number of Certifications per learning intervention",{"$f":"Dashboard!N4","v":"Status quo"},{"$f":"SUM(C36:C38)","v":33015},36866,42789,48712,54635,60559,66481,72404,{"$f":"SUM(K36:K38)","v":78328},84251,90174,96097,102020,107944,113867,119791,125713]
[null,"AET Level 1 to 4",{"$f":"ROUNDUP(((SUM(Enrolments!C3:C6))-C22)*'Enrol Scenarios'!$B$13,0)","v":14180},{"$f":"ROUNDUP((SUM(Enrolments!D3:D6)-D22)*'Enrol Scenarios'!$B$13,0)","v":15834},{"$f":"ROUNDUP((SUM(Enrolments!E3:E6)-E22)*'Enrol Scenarios'!$B$13,0)","v":18378},{"$f":"ROUNDUP((SUM(Enrolments!F3:F6)-F22)*'Enrol Scenarios'!$B$13,0)","v":20922},{"$f":"ROUNDUP((SUM(Enrolments!G3:G6)-G22)*'Enrol Scenarios'!$B$13,0)","v":23466},{"$f":"ROUNDUP((SUM(Enrolments!H3:H6)-H22)*'Enrol Scenarios'!$B$13,0)","v":26010},{"$f":"ROUNDUP((SUM(Enrolments!I3:I6)-I22)*'Enrol Scenarios'!$B$13,0)","v":28554},{"$f":"ROUNDUP((SUM(Enrolments!J3:J6)-J22)*'Enrol Scenarios'!$B$13,0)","v":31098},{"$f":"ROUNDUP((SUM(Enrolments!K3:K6)-K22)*'Enrol Scenarios'!$B$13,0)","v":33642},{"$f":"ROUNDUP((SUM(Enrolments!L3:L6)-L22)*'Enrol Scenarios'!$B$13,0)","v":36186},{"$f":"ROUNDUP((SUM(Enrolments!M3:M6)-M22)*'Enrol Scenarios'!$B$13,0)","v":38730},{"$f":"ROUNDUP((SUM(Enrolments!N3:N6)-N22)*'Enrol Scenarios'!$B$13,0)","v":41274},{"$f":"ROUNDUP((SUM(Enrolments!O3:O6)-O22)*'Enrol Scenarios'!$B$13,0)","v":43818},{"$f":"ROUNDUP((SUM(Enrolments!P3:P6)-P22)*'Enrol Scenarios'!$B$13,0)","v":46362},{"$f":"ROUNDUP((SUM(Enrolments!Q3:Q6)-Q22)*'Enrol Scenarios'!$B$13,0)","v":48906},{"$f":"ROUNDUP((SUM(Enrolments!R3:R6)-R22)*'Enrol Scenarios'!$B$13,0)","v":51450},{"$f":"ROUNDUP((SUM(Enrolments!S3:S6)-S22)*'Enrol Scenarios'!$B$13,0)","v":53994}]
[null,"Grade 12",{"$f":"ROUNDUP((Enrolments!C7-'Learner Numbers'!C23)*'Enrol Scenarios'!$B$14,0)","v":12986},{"$f":"ROUNDUP((Enrolments!D7-'Learner Numbers'!D23)*'Enrol Scenarios'!$B$14,0)","v":14501},{"$f":"ROUNDUP((Enrolments!E7-'Learner Numbers'!E23)*'Enrol Scenarios'!$B$14,0)","v":16830},{"$f":"ROUNDUP((Enrolments!F7-'Learner Numbers'!F23)*'Enrol Scenarios'!$B$14,0)","v":19160},{"$f":"ROUNDUP((Enrolments!G7-'Learner Numbers'!G23)*'Enrol Scenarios'!$B$14,0)","v":21490},{"$f":"ROUNDUP((Enrolments!H7-'Learner Numbers'!H23)*'Enrol Scenarios'!$B$14,0)","v":23820},{"$f":"ROUNDUP((Enrolments!I7-'Learner Numbers'!I23)*'Enrol Scenarios'!$B$14,0)","v":26149},{"$f":"ROUNDUP((Enrolments!J7-'Learner Numbers'!J23)*'Enrol Scenarios'!$B$14,0)","v":28479},{"$f":"ROUNDUP((Enrolments!K7-'Learner Numbers'!K23)*'Enrol Scenarios'!$B$14,0)","v":30809},{"$f":"ROUNDUP((Enrolments!L7-'Learner Numbers'!L23)*'Enrol Scenarios'!$B$14,0)","v":33139},{"$f":"ROUNDUP((Enrolments!M7-'Learner Numbers'!M23)*'Enrol Scenarios'!$B$14,0)","v":35469},{"$f":"ROUNDUP((Enrolments!N7-'Learner Numbers'!N23)*'Enrol Scenarios'!$B$14,0)","v":37798},{"$f":"ROUNDUP((Enrolments!O7-'Learner Numbers'!O23)*'Enrol Scenarios'!$B$14,0)","v":40128},{"$f":"ROUNDUP((Enrolments!P7-'Learner Numbers'!P23)*'Enrol Scenarios'!$B$14,0)","v":42458},{"$f":"ROUNDUP((Enrolments!Q7-'Learner Numbers'!Q23)*'Enrol Scenarios'!$B$14,0)","v":44788},{"$f":"ROUNDUP((Enrolments!R7-'Learner Numbers'!R23)*'Enrol Scenarios'!$B$14,0)","v":47118},{"$f":"ROUNDUP((Enrolments!S7-'Learner Numbers'!S23)*'Enrol Scenarios'!$B$14,0)","v":49447}]
[null,"Occupational Programmes",{"$f":"ROUNDUP((Enrolments!C8-'Learner Numbers'!C24)*'Enrol Scenarios'!$B$15,0)","v":5849},{"$f":"ROUNDUP((Enrolments!D8-'Learner Numbers'!D24)*'Enrol Scenarios'!$B$15,0)","v":6531},{"$f":"ROUNDUP((Enrolments!E8-'Learner Numbers'!E24)*'Enrol Scenarios'!$B$15,0)","v":7581},{"$f":"ROUNDUP((Enrolments!F8-'Learner Numbers'!F24)*'Enrol Scenarios'!$B$15,0)","v":8630},{"$f":"ROUNDUP((Enrolments!G8-'Learner Numbers'!G24)*'Enrol Scenarios'!$B$15,0)","v":9679},{"$f":"ROUNDUP((Enrolments!H8-'Learner Numbers'!H24)*'Enrol Scenarios'!$B$15,0)","v":10729},{"$f":"ROUNDUP((Enrolments!I8-'Learner Numbers'!I24)*'Enrol Scenarios'!$B$15,0)","v":11778},{"$f":"ROUNDUP((Enrolments!J8-'Learner Numbers'!J24)*'Enrol Scenarios'!$B$15,0)","v":12827},{"$f":"ROUNDUP((Enrolments!K8-'Learner Numbers'!K24)*'Enrol Scenarios'!$B$15,0)","v":13877},{"$f":"ROUNDUP((Enrolments!L8-'Learner Numbers'!L24)*'Enrol Scenarios'!$B$15,0)","v":14926},{"$f":"ROUNDUP((Enrolments!M8-'Learner Numbers'!M24)*'Enrol Scenarios'!$B$15,0)","v":15975},{"$f":"ROUNDUP((Enrolments!N8-'Learner Numbers'!N24)*'Enrol Scenarios'!$B$15,0)","v":17025},{"$f":"ROUNDUP((Enrolments!O8-'Learner Numbers'!O24)*'Enrol Scenarios'!$B$15,0)","v":18074},{"$f":"ROUNDUP((Enrolments!P8-'Learner Numbers'!P24)*'Enrol Scenarios'!$B$15,0)","v":19124},{"$f":"ROUNDUP((Enrolments!Q8-'Learner Numbers'!Q24)*'Enrol Scenarios'!$B$15,0)","v":20173},{"$f":"ROUNDUP((Enrolments!R8-'Learner Numbers'!R24)*'Enrol Scenarios'!$B$15,0)","v":21223},{"$f":"ROUNDUP((Enrolments!S8-'Learner Numbers'!S24)*'Enrol Scenarios'!$B$15,0)","v":22272}]
[null,{"$f":"Dashboard!O4","v":"Full Policy"},{"$f":"SUM(C40:C42)","v":35085},39177,59315,79453,99591,119730,139867,160006,{"$f":"SUM(K40:K42)","v":180145},200282,220419,240559,260697,280834,300973,321111,341249]
[null,"AET Level 1 to 4",{"$f":"ROUNDUP(((SUM(Enrolments!C19:C22)-C26))*'Enrol Scenarios'!$C$13,0)","v":16250},{"$f":"ROUNDUP(((SUM(Enrolments!D19:D22)-D26))*'Enrol Scenarios'!$C$13,0)","v":18145},{"$f":"ROUNDUP(((SUM(Enrolments!E19:E22)-E26))*'Enrol Scenarios'!$C$13,0)","v":19815},{"$f":"ROUNDUP(((SUM(Enrolments!F19:F22)-F26))*'Enrol Scenarios'!$C$13,0)","v":21486},{"$f":"ROUNDUP(((SUM(Enrolments!G19:G22)-G26))*'Enrol Scenarios'!$C$13,0)","v":23156},{"$f":"ROUNDUP(((SUM(Enrolments!H19:H22)-H26))*'Enrol Scenarios'!$C$13,0)","v":24826},{"$f":"ROUNDUP(((SUM(Enrolments!I19:I22)-I26))*'Enrol Scenarios'!$C$13,0)","v":26497},{"$f":"ROUNDUP(((SUM(Enrolments!J19:J22)-J26))*'Enrol Scenarios'!$C$13,0)","v":28167},{"$f":"ROUNDUP(((SUM(Enrolments!K19:K22)-K26))*'Enrol Scenarios'!$C$13,0)","v":29838},{"$f":"ROUNDUP(((SUM(Enrolments!L19:L22)-L26))*'Enrol Scenarios'!$C$13,0)","v":31508},{"$f":"ROUNDUP(((SUM(Enrolments!M19:M22)-M26))*'Enrol Scenarios'!$C$13,0)","v":33178},{"$f":"ROUNDUP(((SUM(Enrolments!N19:N22)-N26))*'Enrol Scenarios'!$C$13,0)","v":34849},{"$f":"ROUNDUP(((SUM(Enrolments!O19:O22)-O26))*'Enrol Scenarios'!$C$13,0)","v":36519},{"$f":"ROUNDUP(((SUM(Enrolments!P19:P22)-P26))*'Enrol Scenarios'!$C$13,0)","v":38189},{"$f":"ROUNDUP(((SUM(Enrolments!Q19:Q22)-Q26))*'Enrol Scenarios'!$C$13,0)","v":39860},{"$f":"ROUNDUP(((SUM(Enrolments!R19:R22)-R26))*'Enrol Scenarios'!$C$13,0)","v":41530},{"$f":"ROUNDUP(((SUM(Enrolments!S19:S22)-S26))*'Enrol Scenarios'!$C$13,0)","v":43200}]
[null,"Grade 12",{"$f":"ROUNDUP((Enrolments!C23-C27)*'Enrol Scenarios'!$C$14,0)","v":12986},{"$f":"ROUNDUP((Enrolments!D23-D27)*'Enrol Scenarios'!$C$14,0)","v":14501},{"$f":"ROUNDUP((Enrolments!E23-E27)*'Enrol Scenarios'!$C$14,0)","v":15484},{"$f":"ROUNDUP((Enrolments!F23-F27)*'Enrol Scenarios'!$C$14,0)","v":16467},{"$f":"ROUNDUP((Enrolments!G23-G27)*'Enrol Scenarios'!$C$14,0)","v":17450},{"$f":"ROUNDUP((Enrolments!H23-H27)*'Enrol Scenarios'!$C$14,0)","v":18434},{"$f":"ROUNDUP((Enrolments!I23-I27)*'Enrol Scenarios'!$C$14,0)","v":19416},{"$f":"ROUNDUP((Enrolments!J23-J27)*'Enrol Scenarios'!$C$14,0)","v":20400},{"$f":"ROUNDUP((Enrolments!K23-K27)*'Enrol Scenarios'!$C$14,0)","v":21383},{"$f":"ROUNDUP((Enrolments!L23-L27)*'Enrol Scenarios'!$C$14,0)","v":22366},{"$f":"ROUNDUP((Enrolments!M23-M27)*'Enrol Scenarios'!$C$14,0)","v":23349},{"$f":"ROUNDUP((Enrolments!N23-N27)*'Enrol Scenarios'!$C$14,0)","v":24333},{"$f":"ROUNDUP((Enrolments!O23-O27)*'Enrol Scenarios'!$C$14,0)","v":25316},{"$f":"ROUNDUP((Enrolments!P23-P27)*'Enrol Scenarios'!$C$14,0)","v":26299},{"$f":"ROUNDUP((Enrolments!Q23-Q27)*'Enrol Scenarios'!$C$14,0)","v":27282},{"$f":"ROUNDUP((Enrolments!R23-R27)*'Enrol Scenarios'!$C$14,0)","v":28266},{"$f":"ROUNDUP((Enrolments!S23-S27)*'Enrol Scenarios'!$C$14,0)","v":29249}]
[null,"Occupational Programmes",{"$f":"ROUNDUP((Enrolments!C24-C28)*'Enrol Scenarios'!$C$15,0)","v":5849},{"$f":"ROUNDUP((Enrolments!D24-D28)*'Enrol Scenarios'!$C$15,0)","v":6531},{"$f":"ROUNDUP((Enrolments!E24-E28)*'Enrol Scenarios'!$C$15,0)","v":24016},{"$f":"ROUNDUP((Enrolments!F24-F28)*'Enrol Scenarios'!$C$15,0)","v":41500},{"$f":"ROUNDUP((Enrolments!G24-G28)*'Enrol Scenarios'!$C$15,0)","v":58985},{"$f":"ROUNDUP((Enrolments!H24-H28)*'Enrol Scenarios'!$C$15,0)","v":76470},{"$f":"ROUNDUP((Enrolments!I24-I28)*'Enrol Scenarios'!$C$15,0)","v":93954},{"$f":"ROUNDUP((Enrolments!J24-J28)*'Enrol Scenarios'!$C$15,0)","v":111439},{"$f":"ROUNDUP((Enrolments!K24-K28)*'Enrol Scenarios'!$C$15,0)","v":128924},{"$f":"ROUNDUP((Enrolments!L24-L28)*'Enrol Scenarios'!$C$15,0)","v":146408},{"$f":"ROUNDUP((Enrolments!M24-M28)*'Enrol Scenarios'!$C$15,0)","v":163892},{"$f":"ROUNDUP((Enrolments!N24-N28)*'Enrol Scenarios'!$C$15,0)","v":181377},{"$f":"ROUNDUP((Enrolments!O24-O28)*'Enrol Scenarios'!$C$15,0)","v":198862},{"$f":"ROUNDUP((Enrolments!P24-P28)*'Enrol Scenarios'!$C$15,0)","v":216346},{"$f":"ROUNDUP((Enrolments!Q24-Q28)*'Enrol Scenarios'!$C$15,0)","v":233831},{"$f":"ROUNDUP((Enrolments!R24-R28)*'Enrol Scenarios'!$C$15,0)","v":251315},{"$f":"ROUNDUP((Enrolments!S24-S28)*'Enrol Scenarios'!$C$15,0)","v":268800}]
[null,{"$f":"Dashboard!P4","v":"Mixed"},{"$f":"SUM(C44:C46)","v":32230},42946,53662,64378,75094,85809,96525,107241,{"$f":"SUM(K44:K46)","v":117957},128673,139389,150106,160821,171536,182252,192969,203685]
[null,"AET Level 1 to 4",{"$f":"ROUNDUP(((SUM(Enrolments!C27:C30))-C30)*'Enrol Scenarios'!$D$13,0)","v":14180},{"$f":"ROUNDUP(((SUM(Enrolments!D27:D30))-D30)*'Enrol Scenarios'!$D$13,0)","v":15241},{"$f":"ROUNDUP(((SUM(Enrolments!E27:E30))-E30)*'Enrol Scenarios'!$D$13,0)","v":16302},{"$f":"ROUNDUP(((SUM(Enrolments!F27:F30))-F30)*'Enrol Scenarios'!$D$13,0)","v":17363},{"$f":"ROUNDUP(((SUM(Enrolments!G27:G30))-G30)*'Enrol Scenarios'!$D$13,0)","v":18424},{"$f":"ROUNDUP(((SUM(Enrolments!H27:H30))-H30)*'Enrol Scenarios'!$D$13,0)","v":19484},{"$f":"ROUNDUP(((SUM(Enrolments!I27:I30))-I30)*'Enrol Scenarios'!$D$13,0)","v":20545},{"$f":"ROUNDUP(((SUM(Enrolments!J27:J30))-J30)*'Enrol Scenarios'!$D$13,0)","v":21606},{"$f":"ROUNDUP(((SUM(Enrolments!K27:K30))-K30)*'Enrol Scenarios'!$D$13,0)","v":22667},{"$f":"ROUNDUP(((SUM(Enrolments!L27:L30))-L30)*'Enrol Scenarios'!$D$13,0)","v":23728},{"$f":"ROUNDUP(((SUM(Enrolments!M27:M30))-M30)*'Enrol Scenarios'!$D$13,0)","v":24789},{"$f":"ROUNDUP(((SUM(Enrolments!N27:N30))-N30)*'Enrol Scenarios'!$D$13,0)","v":25850},{"$f":"ROUNDUP(((SUM(Enrolments!O27:O30))-O30)*'Enrol Scenarios'!$D$13,0)","v":26910},{"$f":"ROUNDUP(((SUM(Enrolments!P27:P30))-P30)*'Enrol Scenarios'!$D$13,0)","v":27971},{"$f":"ROUNDUP(((SUM(Enrolments!Q27:Q30))-Q30)*'Enrol Scenarios'!$D$13,0)","v":29032},{"$f":"ROUNDUP(((SUM(Enrolments!R27:R30))-R30)*'Enrol Scenarios'!$D$13,0)","v":30093},{"$f":"ROUNDUP(((SUM(Enrolments!S27:S30))-S30)*'Enrol Scenarios'!$D$13,0)","v":31154}]
[null,"Grade 12",{"$f":"ROUNDUP((Enrolments!C31-C31)*'Enrol Scenarios'!$D$14,0)","v":12986},{"$f":"ROUNDUP((Enrolments!D31-D31)*'Enrol Scenarios'!$D$14,0)","v":13957},{"$f":"ROUNDUP((Enrolments!E31-E31)*'Enrol Scenarios'!$D$14,0)","v":14929},{"$f":"ROUNDUP((Enrolments!F31-F31)*'Enrol Scenarios'!$D$14,0)","v":15901},{"$f":"ROUNDUP((Enrolments!G31-G31)*'Enrol Scenarios'!$D$14,0)","v":16872},{"$f":"ROUNDUP((Enrolments!H31-H31)*'Enrol Scenarios'!$D$14,0)","v":17844},{"$f":"ROUNDUP((Enrolments!I31-I31)*'Enrol Scenarios'!$D$14,0)","v":18815},{"$f":"ROUNDUP((Enrolments!J31-J31)*'Enrol Scenarios'!$D$14,0)","v":19787},{"$f":"ROUNDUP((Enrolments!K31-K31)*'Enrol Scenarios'!$D$14,0)","v":20758},{"$f":"ROUNDUP((Enrolments!L31-L31)*'Enrol Scenarios'!$D$14,0)","v":21730},{"$f":"ROUNDUP((Enrolments!M31-M31)*'Enrol Scenarios'!$D$14,0)","v":22701},{"$f":"ROUNDUP((Enrolments!N31-N31)*'Enrol Scenarios'!$D$14,0)","v":23673},{"$f":"ROUNDUP((Enrolments!O31-O31)*'Enrol Scenarios'!$D$14,0)","v":24645},{"$f":"ROUNDUP((Enrolments!P31-P31)*'Enrol Scenarios'!$D$14,0)","v":25616},{"$f":"ROUNDUP((Enrolments!Q31-Q31)*'Enrol Scenarios'!$D$14,0)","v":26587},{"$f":"ROUNDUP((Enrolments!R31-R31)*'Enrol Scenarios'!$D$14,0)","v":27559},{"$f":"ROUNDUP((Enrolments!S31-S31)*'Enrol Scenarios'!$D$14,0)","v":28531}]
[null,"Occupational Programmes",{"$f":"ROUNDUP((Enrolments!C32-C32)*'Enrol Scenarios'!$D$15,0)","v":5064},{"$f":"ROUNDUP((Enrolments!D32-D32)*'Enrol Scenarios'!$D$15,0)","v":13748},{"$f":"ROUNDUP((Enrolments!E32-E32)*'Enrol Scenarios'!$D$15,0)","v":22431},{"$f":"ROUNDUP((Enrolments!F32-F32)*'Enrol Scenarios'!$D$15,0)","v":31114},{"$f":"ROUNDUP((Enrolments!G32-G32)*'Enrol Scenarios'!$D$15,0)","v":39798},{"$f":"ROUNDUP((Enrolments!H32-H32)*'Enrol Scenarios'!$D$15,0)","v":48481},{"$f":"ROUNDUP((Enrolments!I32-I32)*'Enrol Scenarios'!$D$15,0)","v":57165},{"$f":"ROUNDUP((Enrolments!J32-J32)*'Enrol Scenarios'!$D$15,0)","v":65848},{"$f":"ROUNDUP((Enrolments!K32-K32)*'Enrol Scenarios'!$D$15,0)","v":74532},{"$f":"ROUNDUP((Enrolments!L32-L32)*'Enrol Scenarios'!$D$15,0)","v":83215},{"$f":"ROUNDUP((Enrolments!M32-M32)*'Enrol Scenarios'!$D$15,0)","v":91899},{"$f":"ROUNDUP((Enrolments!N32-N32)*'Enrol Scenarios'!$D$15,0)","v":100583},{"$f":"ROUNDUP((Enrolments!O32-O32)*'Enrol Scenarios'!$D$15,0)","v":109266},{"$f":"ROUNDUP((Enrolments!P32-P32)*'Enrol Scenarios'!$D$15,0)","v":117949},{"$f":"ROUNDUP((Enrolments!Q32-Q32)*'Enrol Scenarios'!$D$15,0)","v":126633},{"$f":"ROUNDUP((Enrolments!R32-R32)*'Enrol Scenarios'!$D$15,0)","v":135317},{"$f":"ROUNDUP((Enrolments!S32-S32)*'Enrol Scenarios'!$D$15,0)","v":144000}]
[]
[null,"Throughput"]
["Number of completions per learning intervention","Status Quo",{"$f":"SUM(C50:C52)","v":89548.775367276277},{"$f":"SUM(D50:D52)","v":{"$error":"#REF!"}},{"$f":"SUM(E50:E52)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(K50:K52)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"AET Level 1 to 4",{"$f":"SUM(Enrolments!C3:C6)-'Learner Numbers'!C22-'Learner Numbers'!C36","v":67067.819155374396},{"$f":"ROUNDUP(D12*D76,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Grade 12",{"$f":"Enrolments!C7-'Learner Numbers'!C31-'Learner Numbers'!C37","v":20977.947211901876},{"$f":"ROUNDUP(D16*D77,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Occupational Programmes",{"$f":"Enrolments!C8-'Learner Numbers'!C32-'Learner Numbers'!C38","v":1503.009},{"$f":"ROUNDUP(D17*D78,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Full White Paper"]
[null,"AET Level 1 to 4"]
[null,"Grade 12"]
[null,"Occupational Programmes"]
[null,"Pragmatic"]
[null,"AET Level 1 to 4"]
[null,"Grade 12"]
[null,"Occupational Programmes"]
[]
[null,"Learning Intervention Mix"]
[null,"AET Level 1",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"AET Level 2",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"AET Level 3",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"AET Level 4",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Grade 12",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Occupational Programmes",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,"Dropouts per learning intervention"]
[null,"AET Level 1 to 4",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Grade 10 to 12",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Occupational Programmes",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,"Throughput per learning intervention"]
[null,"AET Level 1 to 4",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Grade 10 to 12",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Occupational Programmes",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]

{"sheet":"Enrolments","index":4,"n_rows":112,"n_cols":19,"rows_kept":112,"cut":false,"hidden":false,"merged":[[97,0,103,0],[105,0,111,0],[33,0,39,0],[55,0,59,0],[49,0,53,0],[43,0,47,0],[1,0,7,0],[9,0,15,0],[17,0,23,0],[25,0,31,0],[89,0,95,0]]}
[null,null,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[{"$f":"Dashboard!N4","v":"Status quo"},"Total Enrolment",262621,293248,{"$f":"D2+($S2-$D2)/($S$1-$D$1)","v":340364.79999999999},{"$f":"E2+($S2-$D2)/($S$1-$D$1)","v":387481.59999999998},434598.39999999997,481715.19999999995,528832,575948.80000000005,623065.60000000009,670182.40000000014,717299.20000000019,764416.00000000023,811532.80000000028,858649.60000000033,905766.40000000037,952883.20000000042,{"$f":"Dashboard!E6","v":1000000}]
[null,"Abet 1",{"$f":"C$2*'Enrol Scenarios'!$B$4","v":15817.866384510255},{"$f":"D$2*'Enrol Scenarios'!$B$4","v":17662.554333144963},{"$f":"E$2*'Enrol Scenarios'!$B$4","v":20500.435716833596},{"$f":"F$2*'Enrol Scenarios'!$B$4","v":23338.317100522228},{"$f":"G$2*'Enrol Scenarios'!$B$4","v":26176.198484210861},{"$f":"H$2*'Enrol Scenarios'!$B$4","v":29014.079867899494},{"$f":"I$2*'Enrol Scenarios'!$B$4","v":31851.961251588131},{"$f":"J$2*'Enrol Scenarios'!$B$4","v":34689.842635276771},{"$f":"K$2*'Enrol Scenarios'!$B$4","v":37527.724018965404},{"$f":"L$2*'Enrol Scenarios'!$B$4","v":40365.605402654044},{"$f":"M$2*'Enrol Scenarios'!$B$4","v":43203.486786342677},{"$f":"N$2*'Enrol Scenarios'!$B$4","v":46041.368170031317},{"$f":"O$2*'Enrol Scenarios'!$B$4","v":48879.24955371995},{"$f":"P$2*'Enrol Scenarios'!$B$4","v":51717.13093740859},{"$f":"Q$2*'Enrol Scenarios'!$B$4","v":54555.012321097223},{"$f":"R$2*'Enrol Scenarios'!$B$4","v":57392.893704785864},{"$f":"S$2*'Enrol Scenarios'!$B$4","v":60230.775088474475}]
[null,"Abet 2",{"$f":"C$2*'Enrol Scenarios'!$B$5","v":22699.501360683265},{"$f":"D$2*'Enrol Scenarios'!$B$5","v":25346.729222025835},{"$f":"E$2*'Enrol Scenarios'!$B$5","v":29419.243856084195},{"$f":"F$2*'Enrol Scenarios'!$B$5","v":33491.758490142558},{"$f":"G$2*'Enrol Scenarios'!$B$5","v":37564.273124200918},{"$f":"H$2*'Enrol Scenarios'!$B$5","v":41636.787758259285},{"$f":"I$2*'Enrol Scenarios'!$B$5","v":45709.302392317652},{"$f":"J$2*'Enrol Scenarios'!$B$5","v":49781.817026376018},{"$f":"K$2*'Enrol Scenarios'!$B$5","v":53854.331660434385},{"$f":"L$2*'Enrol Scenarios'!$B$5","v":57926.846294492752},{"$f":"M$2*'Enrol Scenarios'!$B$5","v":61999.360928551119},{"$f":"N$2*'Enrol Scenarios'!$B$5","v":66071.875562609479},{"$f":"O$2*'Enrol Scenarios'!$B$5","v":70144.390196667853},{"$f":"P$2*'Enrol Scenarios'!$B$5","v":74216.904830726213},{"$f":"Q$2*'Enrol Scenarios'!$B$5","v":78289.419464784587},{"$f":"R$2*'Enrol Scenarios'!$B$5","v":82361.934098842947},{"$f":"S$2*'Enrol Scenarios'!$B$5","v":86434.448732901277}]
[null,"Abet 3",{"$f":"C$2*'Enrol Scenarios'!$B$6","v":26933.94882307911},{"$f":"D$2*'Enrol Scenarios'!$B$6","v":30075.000188371469},{"$f":"E$2*'Enrol Scenarios'!$B$6","v":34907.216499737478},{"$f":"F$2*'Enrol Scenarios'!$B$6","v":39739.432811103492},{"$f":"G$2*'Enrol Scenarios'!$B$6","v":44571.649122469506},{"$f":"H$2*'Enrol Scenarios'!$B$6","v":49403.865433835519},{"$f":"I$2*'Enrol Scenarios'!$B$6","v":54236.081745201533},{"$f":"J$2*'Enrol Scenarios'!$B$6","v":59068.298056567553},{"$f":"K$2*'Enrol Scenarios'!$B$6","v":63900.514367933574},{"$f":"L$2*'Enrol Scenarios'!$B$6","v":68732.730679299595},{"$f":"M$2*'Enrol Scenarios'!$B$6","v":73564.946990665601},{"$f":"N$2*'Enrol Scenarios'!$B$6","v":78397.163302031622},{"$f":"O$2*'Enrol Scenarios'!$B$6","v":83229.379613397643},{"$f":"P$2*'Enrol Scenarios'!$B$6","v":88061.595924763664},{"$f":"Q$2*'Enrol Scenarios'!$B$6","v":92893.812236129685},{"$f":"R$2*'Enrol Scenarios'!$B$6","v":97726.028547495705},{"$f":"S$2*'Enrol Scenarios'!$B$6","v":102558.24485886167}]
[null,"Abet 4",{"$f":"C$2*'Enrol Scenarios'!$B$7","v":115099.50258710177},{"$f":"D$2*'Enrol Scenarios'!$B$7","v":128522.46748989007},{"$f":"E$2*'Enrol Scenarios'!$B$7","v":149172.4545187109},{"$f":"F$2*'Enrol Scenarios'!$B$7","v":169822.44154753172},{"$f":"G$2*'Enrol Scenarios'!$B$7","v":190472.42857635257},{"$f":"H$2*'Enrol Scenarios'!$B$7","v":211122.41560517339},{"$f":"I$2*'Enrol Scenarios'!$B$7","v":231772.40263399426},{"$f":"J$2*'Enrol Scenarios'!$B$7","v":252422.38966281511},{"$f":"K$2*'Enrol Scenarios'!$B$7","v":273072.37669163599},{"$f":"L$2*'Enrol Scenarios'!$B$7","v":293722.36372045684},{"$f":"M$2*'Enrol Scenarios'!$B$7","v":314372.35074927768},{"$f":"N$2*'Enrol Scenarios'!$B$7","v":335022.33777809853},{"$f":"O$2*'Enrol Scenarios'!$B$7","v":355672.32480691938},{"$f":"P$2*'Enrol Scenarios'!$B$7","v":376322.31183574023},{"$f":"Q$2*'Enrol Scenarios'!$B$7","v":396972.29886456107},{"$f":"R$2*'Enrol Scenarios'!$B$7","v":417622.28589338198},{"$f":"S$2*'Enrol Scenarios'!$B$7","v":438272.2729222026}]
[null,"Grade 12",{"$f":"C$2*'Enrol Scenarios'!$B$8","v":75476.947211901876},{"$f":"D$2*'Enrol Scenarios'!$B$8","v":84279.108738432187},{"$f":"E$2*'Enrol Scenarios'!$B$8","v":97820.418178247506},{"$f":"F$2*'Enrol Scenarios'!$B$8","v":111361.72761806281},{"$f":"G$2*'Enrol Scenarios'!$B$8","v":124903.03705787813},{"$f":"H$2*'Enrol Scenarios'!$B$8","v":138444.34649769345},{"$f":"I$2*'Enrol Scenarios'!$B$8","v":151985.65593750877},{"$f":"J$2*'Enrol Scenarios'!$B$8","v":165526.96537732409},{"$f":"K$2*'Enrol Scenarios'!$B$8","v":179068.27481713943},{"$f":"L$2*'Enrol Scenarios'!$B$8","v":192609.58425695475},{"$f":"M$2*'Enrol Scenarios'!$B$8","v":206150.89369677007},{"$f":"N$2*'Enrol Scenarios'!$B$8","v":219692.20313658542},{"$f":"O$2*'Enrol Scenarios'!$B$8","v":233233.51257640074},{"$f":"P$2*'Enrol Scenarios'!$B$8","v":246774.82201621606},{"$f":"Q$2*'Enrol Scenarios'!$B$8","v":260316.13145603141},{"$f":"R$2*'Enrol Scenarios'!$B$8","v":273857.44089584675},{"$f":"S$2*'Enrol Scenarios'!$B$8","v":287398.75033566193}]
[null,"Occupational",{"$f":"C$2*'Enrol Scenarios'!$B$9","v":7616.009},{"$f":"D$2*'Enrol Scenarios'!$B$9","v":8504.1920000000009},{"$f":"E$2*'Enrol Scenarios'!$B$9","v":9870.5792000000001},{"$f":"F$2*'Enrol Scenarios'!$B$9","v":11236.966399999999},{"$f":"G$2*'Enrol Scenarios'!$B$9","v":12603.3536},{"$f":"H$2*'Enrol Scenarios'!$B$9","v":13969.7408},{"$f":"I$2*'Enrol Scenarios'!$B$9","v":15336.128000000001},{"$f":"J$2*'Enrol Scenarios'!$B$9","v":16702.515200000002},{"$f":"K$2*'Enrol Scenarios'!$B$9","v":18068.902400000003},{"$f":"L$2*'Enrol Scenarios'!$B$9","v":19435.289600000004},{"$f":"M$2*'Enrol Scenarios'!$B$9","v":20801.676800000005},{"$f":"N$2*'Enrol Scenarios'!$B$9","v":22168.064000000009},{"$f":"O$2*'Enrol Scenarios'!$B$9","v":23534.45120000001},{"$f":"P$2*'Enrol Scenarios'!$B$9","v":24900.838400000011},{"$f":"Q$2*'Enrol Scenarios'!$B$9","v":26267.225600000012},{"$f":"R$2*'Enrol Scenarios'!$B$9","v":27633.612800000014},{"$f":"S$2*'Enrol Scenarios'!$B$9","v":29000}]
[null,null,{"$f":"C2/D2","v":0.89555939000436491},{"$f":"1-C9","v":0.10444060999563509},{"$f":"($S$10/$D$10)^(1/($S$1-$D$1))-1","v":8.0585099355972023E-2},{"$f":"($S$10/$D$10)^(1/($S$1-$D$1))-1","v":8.0585099355972023E-2},8.0585099355972023E-2,8.0585099355972023E-2,8.0585099355972023E-2,8.0585099355972023E-2,8.0585099355972023E-2,8.0585099355972023E-2,8.0585099355972023E-2,8.0585099355972023E-2,8.0585099355972023E-2,8.0585099355972023E-2,8.0585099355972023E-2,8.0585099355972023E-2]
["Constant Growth","Total Enrolment",293248,312691,{"$f":"D10*(1+E9)","v":337889.23530271824},{"$f":"E10*(1+F9)","v":365118.0729009012},394541.14908228134,426335.28678109637,460691.55822530785,497816.43321735185,537933.01994920778,581282.40580867277,628125.10623464314,678742.63032854232,733439.17263070168,792543.44122870872,856410.63318404823,925424.56914869568,{"$f":"Dashboard!F6","v":1000000}]
[null,"Abet 1",{"$f":"C$10*#REF!","v":{"$error":"#REF!"}},{"$f":"D$10*#REF!","v":{"$error":"#REF!"}},{"$f":"E$10*#REF!","v":{"$error":"#REF!"}},{"$f":"F$10*#REF!","v":{"$error":"#REF!"}},{"$f":"G$10*#REF!","v":{"$error":"#REF!"}},{"$f":"H$10*#REF!","v":{"$error":"#REF!"}},{"$f":"I$10*#REF!","v":{"$error":"#REF!"}},{"$f":"J$10*#REF!","v":{"$error":"#REF!"}},{"$f":"K$10*#REF!","v":{"$error":"#REF!"}},{"$f":"L$10*#REF!","v":{"$error":"#REF!"}},{"$f":"M$10*#REF!","v":{"$error":"#REF!"}},{"$f":"N$10*#REF!","v":{"$error":"#REF!"}},{"$f":"O$10*#REF!","v":{"$error":"#REF!"}},{"$f":"P$10*#REF!","v":{"$error":"#REF!"}},{"$f":"Q$10*#REF!","v":{"$error":"#REF!"}},{"$f":"R$10*#REF!","v":{"$error":"#REF!"}},{"$f":"S$10*#REF!","v":{"$error":"#REF!"}}]
[null,"Abet 2",{"$f":"C$10*#REF!","v":{"$error":"#REF!"}},{"$f":"D$10*#REF!","v":{"$error":"#REF!"}},{"$f":"E$10*#REF!","v":{"$error":"#REF!"}},{"$f":"F$10*#REF!","v":{"$error":"#REF!"}},{"$f":"G$10*#REF!","v":{"$error":"#REF!"}},{"$f":"H$10*#REF!","v":{"$error":"#REF!"}},{"$f":"I$10*#REF!","v":{"$error":"#REF!"}},{"$f":"J$10*#REF!","v":{"$error":"#REF!"}},{"$f":"K$10*#REF!","v":{"$error":"#REF!"}},{"$f":"L$10*#REF!","v":{"$error":"#REF!"}},{"$f":"M$10*#REF!","v":{"$error":"#REF!"}},{"$f":"N$10*#REF!","v":{"$error":"#REF!"}},{"$f":"O$10*#REF!","v":{"$error":"#REF!"}},{"$f":"P$10*#REF!","v":{"$error":"#REF!"}},{"$f":"Q$10*#REF!","v":{"$error":"#REF!"}},{"$f":"R$10*#REF!","v":{"$error":"#REF!"}},{"$f":"S$10*#REF!","v":{"$error":"#REF!"}}]
[null,"Abet 3",{"$f":"C$10*#REF!","v":{"$error":"#REF!"}},{"$f":"D$10*#REF!","v":{"$error":"#REF!"}},{"$f":"E$10*#REF!","v":{"$error":"#REF!"}},{"$f":"F$10*#REF!","v":{"$error":"#REF!"}},{"$f":"G$10*#REF!","v":{"$error":"#REF!"}},{"$f":"H$10*#REF!","v":{"$error":"#REF!"}},{"$f":"I$10*#REF!","v":{"$error":"#REF!"}},{"$f":"J$10*#REF!","v":{"$error":"#REF!"}},{"$f":"K$10*#REF!","v":{"$error":"#REF!"}},{"$f":"L$10*#REF!","v":{"$error":"#REF!"}},{"$f":"M$10*#REF!","v":{"$error":"#REF!"}},{"$f":"N$10*#REF!","v":{"$error":"#REF!"}},{"$f":"O$10*#REF!","v":{"$error":"#REF!"}},{"$f":"P$10*#REF!","v":{"$error":"#REF!"}},{"$f":"Q$10*#REF!","v":{"$error":"#REF!"}},{"$f":"R$10*#REF!","v":{"$error":"#REF!"}},{"$f":"S$10*#REF!","v":{"$error":"#REF!"}}]
[null,"Abet 4",{"$f":"C$10*#REF!","v":{"$error":"#REF!"}},{"$f":"D$10*#REF!","v":{"$error":"#REF!"}},{"$f":"E$10*#REF!","v":{"$error":"#REF!"}},{"$f":"F$10*#REF!","v":{"$error":"#REF!"}},{"$f":"G$10*#REF!","v":{"$error":"#REF!"}},{"$f":"H$10*#REF!","v":{"$error":"#REF!"}},{"$f":"I$10*#REF!","v":{"$error":"#REF!"}},{"$f":"J$10*#REF!","v":{"$error":"#REF!"}},{"$f":"K$10*#REF!","v":{"$error":"#REF!"}},{"$f":"L$10*#REF!","v":{"$error":"#REF!"}},{"$f":"M$10*#REF!","v":{"$error":"#REF!"}},{"$f":"N$10*#REF!","v":{"$error":"#REF!"}},{"$f":"O$10*#REF!","v":{"$error":"#REF!"}},{"$f":"P$10*#REF!","v":{"$error":"#REF!"}},{"$f":"Q$10*#REF!","v":{"$error":"#REF!"}},{"$f":"R$10*#REF!","v":{"$error":"#REF!"}},{"$f":"S$10*#REF!","v":{"$error":"#REF!"}}]
[null,"Grade 12",{"$f":"C$10*#REF!","v":{"$error":"#REF!"}},{"$f":"D$10*#REF!","v":{"$error":"#REF!"}},{"$f":"E$10*#REF!","v":{"$error":"#REF!"}},{"$f":"F$10*#REF!","v":{"$error":"#REF!"}},{"$f":"G$10*#REF!","v":{"$error":"#REF!"}},{"$f":"H$10*#REF!","v":{"$error":"#REF!"}},{"$f":"I$10*#REF!","v":{"$error":"#REF!"}},{"$f":"J$10*#REF!","v":{"$error":"#REF!"}},{"$f":"K$10*#REF!","v":{"$error":"#REF!"}},{"$f":"L$10*#REF!","v":{"$error":"#REF!"}},{"$f":"M$10*#REF!","v":{"$error":"#REF!"}},{"$f":"N$10*#REF!","v":{"$error":"#REF!"}},{"$f":"O$10*#REF!","v":{"$error":"#REF!"}},{"$f":"P$10*#REF!","v":{"$error":"#REF!"}},{"$f":"Q$10*#REF!","v":{"$error":"#REF!"}},{"$f":"R$10*#REF!","v":{"$error":"#REF!"}},{"$f":"S$10*#REF!","v":{"$error":"#REF!"}}]
[null,"Occupational",{"$f":"C$10*#REF!","v":{"$error":"#REF!"}},{"$f":"D$10*#REF!","v":{"$error":"#REF!"}},{"$f":"E$10*#REF!","v":{"$error":"#REF!"}},{"$f":"F$10*#REF!","v":{"$error":"#REF!"}},{"$f":"G$10*#REF!","v":{"$error":"#REF!"}},{"$f":"H$10*#REF!","v":{"$error":"#REF!"}},{"$f":"I$10*#REF!","v":{"$error":"#REF!"}},{"$f":"J$10*#REF!","v":{"$error":"#REF!"}},{"$f":"K$10*#REF!","v":{"$error":"#REF!"}},{"$f":"L$10*#REF!","v":{"$error":"#REF!"}},{"$f":"M$10*#REF!","v":{"$error":"#REF!"}},{"$f":"N$10*#REF!","v":{"$error":"#REF!"}},{"$f":"O$10*#REF!","v":{"$error":"#REF!"}},{"$f":"P$10*#REF!","v":{"$error":"#REF!"}},{"$f":"Q$10*#REF!","v":{"$error":"#REF!"}},{"$f":"R$10*#REF!","v":{"$error":"#REF!"}},{"$f":"S$10*#REF!","v":{"$error":"#REF!"}}]
[]
[{"$f":"Dashboard!O4","v":"Full Policy"},"Total Enrolment",{"$f":"C2","v":262621},293248,{"$f":"D18+($S18-$D18)/($S$1-$D$1)","v":340364.79999999999},{"$f":"E18+($S18-$D18)/($S$1-$D$1)","v":387481.59999999998},434598.39999999997,481715.19999999995,528832,575948.80000000005,623065.60000000009,670182.40000000014,717299.20000000019,764416.00000000023,811532.80000000028,858649.60000000033,905766.40000000037,952883.20000000042,{"$f":"Dashboard!F6","v":1000000}]
[null,"Abet 1",{"$f":"C3","v":15817.866384510255},{"$f":"D$2*'Enrol Scenarios'!$B$4","v":17662.554333144963},22485.050710935298,{"$f":"E19+($S19-$D19)/($S$1-$D$1)","v":27307.547088725634},32130.04346651597,36952.539844306302,41775.036222096634,46597.532599886967,51420.028977677299,56242.525355467631,61065.021733257963,65887.518111048295,70710.014488838628,75532.51086662896,80355.007244419292,85177.503622209624,{"$f":"S$18*'Enrol Scenarios'!C4","v":90000}]
[null,"Abet 2",{"$f":"C4","v":22699.501360683265},{"$f":"D$2*'Enrol Scenarios'!$B$5","v":25346.729222025835},31656.947273890779,{"$f":"E20+($S20-$D20)/($S$1-$D$1)","v":37967.165325755719},44277.383377620659,50587.6014294856,56897.81948135054,63208.03753321548,69518.25558508042,75828.47363694536,82138.691688810301,88448.909740675241,94759.127792540181,101069.34584440512,107379.56389627006,113689.781948135,{"$f":"S$18*'Enrol Scenarios'!C5","v":120000}]
[null,"Abet 3",26933.94882307911,{"$f":"D$2*'Enrol Scenarios'!$B$6","v":30075.000188371469},31403.333509146705,{"$f":"E21+($S21-$D21)/($S$1-$D$1)","v":32731.666829921942},34060.000150697175,35388.333471472411,36716.666792247648,38045.000113022885,39373.333433798121,40701.666754573358,42030.000075348595,43358.333396123831,44686.666716899068,46015.000037674305,47343.333358449541,48671.666679224778,{"$f":"S$18*'Enrol Scenarios'!C6","v":50000}]
[null,"Abet 4",115099.50258710177,{"$f":"D$2*'Enrol Scenarios'!$B$7","v":128522.46748989007},134620.96965723074,{"$f":"E22+($S22-$D22)/($S$1-$D$1)","v":140719.4718245714},146817.97399191206,152916.47615925272,159014.97832659338,165113.48049393404,171211.9826612747,177310.48482861536,183408.98699595602,189507.48916329668,195605.99133063733,201704.49349797799,207802.99566531865,213901.49783265931,{"$f":"S$18*'Enrol Scenarios'!C7","v":220000}]
[null,"Grade 12",75476.947211901876,{"$f":"D$2*'Enrol Scenarios'!$B$8","v":84279.108738432187},89993.834822536708,{"$f":"E23+($S23-$D23)/($S$1-$D$1)","v":95708.560906641229},101423.28699074575,107138.01307485027,112852.73915895479,118567.46524305931,124282.19132716383,129996.91741126835,135711.64349537287,141426.36957947741,147141.09566358192,152855.82174768642,158570.54783179093,164285.27391589544,{"$f":"S$18*'Enrol Scenarios'!C8","v":170000}]
[null,"Occupational",7616.009,{"$f":"D$2*'Enrol Scenarios'!$B$9","v":8504.1920000000009},31270.5792,{"$f":"E24+($S24-$D24)/($S$1-$D$1)","v":54036.966400000005},76803.353600000002,99569.7408,122336.128,145102.51519999999,167868.90239999999,190635.28959999999,213401.67679999999,236168.06399999998,258934.45119999998,281700.83840000001,304467.22560000001,327233.6128,{"$f":"S$18*'Enrol Scenarios'!C9","v":350000}]
[null,null,{"$f":"1-(C18/D18)","v":0.10444060999563509},{"$f":"($S$26/$C$26)^(1/($S$1-$C$1))-1","v":6.7783580364127571E-2},6.3264675006519069E-2,{"$f":"($S$26/$C$26)^(1/($S$1-$C$1))-1","v":6.7783580364127571E-2},6.7783580364127571E-2,6.7783580364127571E-2,6.7783580364127571E-2,6.7783580364127571E-2,6.7783580364127571E-2,6.7783580364127571E-2,6.7783580364127571E-2,6.7783580364127571E-2,6.7783580364127571E-2,6.7783580364127571E-2,6.7783580364127571E-2,6.7783580364127571E-2]
[{"$f":"Dashboard!P4","v":"Mixed"},"Total Enrolment",262621,293248,323698.13333333336,{"$f":"E26*(1+F25)","v":345639.55176785146},369068.23810212867,394085.00467937125,420797.49726435298,449320.65823719499,479777.2211840786,512298.23901308741,547023.6478676321,584102.86926394596,623695.45304361614,665971.76390773908,711113.71448681911,759315.54810076964,750000]
[null,"Abet 1",15817.866384510255,{"$f":"C27+($S27-$C27)/($S$1-$C$1)","v":19516.749735478363},23215.633086446473,{"$f":"E27+($S27-$D27)/($S$1-$D$1)","v":26914.516437414582},30613.399788382692,34312.283139350802,38011.166490318908,41710.049841287015,45408.933192255121,49107.816543223227,52806.699894191333,56505.58324515944,60204.466596127546,63903.349947095652,67602.233298063758,71301.116649031872,{"$f":"$S$26*'Enrol Scenarios'!D4","v":75000}]
[null,"Abet 2",22699.501360683265,25968.282525640563,29237.063690597861,32505.844855555159,35774.626020512456,39043.407185469754,42312.188350427052,45580.96951538435,48849.750680341647,52118.531845298945,55387.313010256243,58656.09417521354,61924.875340170838,65193.656505128136,68462.437670085434,71731.218835042731,{"$f":"$S$26*'Enrol Scenarios'!D5","v":75000}]
[null,"Abet 3",26933.94882307911,28948.990876300522,30964.032929521931,32979.074982743339,34994.117035964751,37009.159089186163,39024.201142407575,41039.243195628987,43054.2852488504,45069.327302071812,47084.369355293224,49099.411408514636,51114.453461736048,53129.49551495746,55144.537568178872,57159.579621400284,{"$f":"$S$26*'Enrol Scenarios'!D6","v":59174.621674621674}]
[null,"Abet 4",115099.50258710177,119624.56258168681,124149.62257627185,{"$f":"E30+($S30-$D30)/($S$1-$D$1)","v":128674.68257085689},133199.74256544193,137724.80256002699,142249.86255461205,146774.9225491971,151299.98254378216,155825.04253836721,160350.10253295227,164875.16252753732,169400.22252212238,173925.28251670743,178450.34251129249,182975.40250587754,{"$f":"$S$26*'Enrol Scenarios'!D7","v":187500.46250046251}]
[null,"Grade 12",75476.947211901876,81123.695250215242,86770.443288528608,92417.191326841974,98063.93936515534,103710.68740346871,109357.43544178207,115004.18348009544,120650.9315184088,126297.67955672217,131944.42759503555,137591.17563334893,143237.92367166231,148884.67170997569,154531.41974828907,160178.16778660245,{"$f":"$S$26*'Enrol Scenarios'!D8","v":165824.91582491584}]
[null,"Occupational",6593.2336327237308,17899.906530678498,29206.579428633264,40513.25232658803,51819.925224542792,63126.598122497555,74433.271020452317,85739.94391840708,97046.616816361842,108353.2897143166,119659.96261227137,130966.63551022613,142273.30840818089,153579.98130613565,164886.65420409042,176193.32710204518,{"$f":"$S$26*'Enrol Scenarios'!D9","v":187500}]
[null,null,null,null,0,{"$f":"($S$34/$D$34)^(1/($S$1-$D$1))-1","v":8.0585099355972023E-2},{"$f":"($S$34/$D$34)^(1/($S$1-$D$1))-1","v":8.0585099355972023E-2},8.0585099355972023E-2,8.0585099355972023E-2,8.0585099355972023E-2,8.0585099355972023E-2,8.0585099355972023E-2,8.0585099355972023E-2,8.0585099355972023E-2,8.0585099355972023E-2,8.0585099355972023E-2,8.0585099355972023E-2,8.0585099355972023E-2]
["Constant Growth","Total Enrolment",293248,312691,{"$f":"D34+($S34-$D34)/($S$1-$D$1)","v":358511.6},{"$f":"E34*(1+F$33)","v":387402.2929062685},418621.14517085149,452355.77174695535,488808.90655743115,528199.62085844576,570764.63978511037,616759.7649910691,666461.41193164035,720168.27102907293,778203.10270296934,840914.67705341382,908679.86985365825,981905.92744858703,1000000]
[null,"Abet 1",{"$f":"C$10*#REF!","v":{"$error":"#REF!"}},{"$f":"D$10*#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"F$10*#REF!","v":{"$error":"#REF!"}},{"$f":"G$10*#REF!","v":{"$error":"#REF!"}},{"$f":"H$10*#REF!","v":{"$error":"#REF!"}},{"$f":"I$10*#REF!","v":{"$error":"#REF!"}},{"$f":"J$10*#REF!","v":{"$error":"#REF!"}},{"$f":"K$10*#REF!","v":{"$error":"#REF!"}},{"$f":"L$10*#REF!","v":{"$error":"#REF!"}},{"$f":"M$10*#REF!","v":{"$error":"#REF!"}},{"$f":"N$10*#REF!","v":{"$error":"#REF!"}},{"$f":"O$10*#REF!","v":{"$error":"#REF!"}},{"$f":"P$10*#REF!","v":{"$error":"#REF!"}},{"$f":"Q$10*#REF!","v":{"$error":"#REF!"}},{"$f":"R$10*#REF!","v":{"$error":"#REF!"}},{"$f":"S$34*'Enrol Scenarios'!C4","v":90000}]
[null,"Abet 2",{"$f":"C$10*#REF!","v":{"$error":"#REF!"}},{"$f":"D$10*#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"F$10*#REF!","v":{"$error":"#REF!"}},{"$f":"G$10*#REF!","v":{"$error":"#REF!"}},{"$f":"H$10*#REF!","v":{"$error":"#REF!"}},{"$f":"I$10*#REF!","v":{"$error":"#REF!"}},{"$f":"J$10*#REF!","v":{"$error":"#REF!"}},{"$f":"K$10*#REF!","v":{"$error":"#REF!"}},{"$f":"L$10*#REF!","v":{"$error":"#REF!"}},{"$f":"M$10*#REF!","v":{"$error":"#REF!"}},{"$f":"N$10*#REF!","v":{"$error":"#REF!"}},{"$f":"O$10*#REF!","v":{"$error":"#REF!"}},{"$f":"P$10*#REF!","v":{"$error":"#REF!"}},{"$f":"Q$10*#REF!","v":{"$error":"#REF!"}},{"$f":"R$10*#REF!","v":{"$error":"#REF!"}},{"$f":"S$34*'Enrol Scenarios'!C5","v":120000}]
[null,"Abet 3",{"$f":"C$10*#REF!","v":{"$error":"#REF!"}},{"$f":"D$10*#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"F$10*#REF!","v":{"$error":"#REF!"}},{"$f":"G$10*#REF!","v":{"$error":"#REF!"}},{"$f":"H$10*#REF!","v":{"$error":"#REF!"}},{"$f":"I$10*#REF!","v":{"$error":"#REF!"}},{"$f":"J$10*#REF!","v":{"$error":"#REF!"}},{"$f":"K$10*#REF!","v":{"$error":"#REF!"}},{"$f":"L$10*#REF!","v":{"$error":"#REF!"}},{"$f":"M$10*#REF!","v":{"$error":"#REF!"}},{"$f":"N$10*#REF!","v":{"$error":"#REF!"}},{"$f":"O$10*#REF!","v":{"$error":"#REF!"}},{"$f":"P$10*#REF!","v":{"$error":"#REF!"}},{"$f":"Q$10*#REF!","v":{"$error":"#REF!"}},{"$f":"R$10*#REF!","v":{"$error":"#REF!"}},{"$f":"S$34*'Enrol Scenarios'!C6","v":50000}]
[null,"Abet 4",{"$f":"C$10*#REF!","v":{"$error":"#REF!"}},{"$f":"D$10*#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"F$10*#REF!","v":{"$error":"#REF!"}},{"$f":"G$10*#REF!","v":{"$error":"#REF!"}},{"$f":"H$10*#REF!","v":{"$error":"#REF!"}},{"$f":"I$10*#REF!","v":{"$error":"#REF!"}},{"$f":"J$10*#REF!","v":{"$error":"#REF!"}},{"$f":"K$10*#REF!","v":{"$error":"#REF!"}},{"$f":"L$10*#REF!","v":{"$error":"#REF!"}},{"$f":"M$10*#REF!","v":{"$error":"#REF!"}},{"$f":"N$10*#REF!","v":{"$error":"#REF!"}},{"$f":"O$10*#REF!","v":{"$error":"#REF!"}},{"$f":"P$10*#REF!","v":{"$error":"#REF!"}},{"$f":"Q$10*#REF!","v":{"$error":"#REF!"}},{"$f":"R$10*#REF!","v":{"$error":"#REF!"}},{"$f":"S$34*'Enrol Scenarios'!C7","v":220000}]
[null,"Grade 12",{"$f":"C$10*#REF!","v":{"$error":"#REF!"}},{"$f":"D$10*#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"F$10*#REF!","v":{"$error":"#REF!"}},{"$f":"G$10*#REF!","v":{"$error":"#REF!"}},{"$f":"H$10*#REF!","v":{"$error":"#REF!"}},{"$f":"I$10*#REF!","v":{"$error":"#REF!"}},{"$f":"J$10*#REF!","v":{"$error":"#REF!"}},{"$f":"K$10*#REF!","v":{"$error":"#REF!"}},{"$f":"L$10*#REF!","v":{"$error":"#REF!"}},{"$f":"M$10*#REF!","v":{"$error":"#REF!"}},{"$f":"N$10*#REF!","v":{"$error":"#REF!"}},{"$f":"O$10*#REF!","v":{"$error":"#REF!"}},{"$f":"P$10*#REF!","v":{"$error":"#REF!"}},{"$f":"Q$10*#REF!","v":{"$error":"#REF!"}},{"$f":"R$10*#REF!","v":{"$error":"#REF!"}},{"$f":"S$34*'Enrol Scenarios'!C8","v":170000}]
[null,"Occupational",{"$f":"C$10*#REF!","v":{"$error":"#REF!"}},{"$f":"D$10*#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"F$10*#REF!","v":{"$error":"#REF!"}},{"$f":"G$10*#REF!","v":{"$error":"#REF!"}},{"$f":"H$10*#REF!","v":{"$error":"#REF!"}},{"$f":"I$10*#REF!","v":{"$error":"#REF!"}},{"$f":"J$10*#REF!","v":{"$error":"#REF!"}},{"$f":"K$10*#REF!","v":{"$error":"#REF!"}},{"$f":"L$10*#REF!","v":{"$error":"#REF!"}},{"$f":"M$10*#REF!","v":{"$error":"#REF!"}},{"$f":"N$10*#REF!","v":{"$error":"#REF!"}},{"$f":"O$10*#REF!","v":{"$error":"#REF!"}},{"$f":"P$10*#REF!","v":{"$error":"#REF!"}},{"$f":"Q$10*#REF!","v":{"$error":"#REF!"}},{"$f":"R$10*#REF!","v":{"$error":"#REF!"}},{"$f":"S$34*'Enrol Scenarios'!C9","v":350000}]
[]
[]
[]
[{"$f":"Dashboard!N4","v":"Status quo"},"Total AET Outpuut",{"$f":"SUM(C45:C48)","v":14179.825020718179},{"$f":"SUM(D45:D48)","v":15833.483718649935},18377.484310895699,20921.484903141456,23465.48549538722,26009.486087632984,28553.486679878748,31097.487272124512,33641.487864370283,36185.488456616047,38729.489048861811,41273.489641107568,43817.490233353339,46361.490825599103,48905.491417844867,51449.492010090631,53993.492602336366]
[null,"AET 1",{"$f":"C3*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":1242.2794788897472},{"$f":"D3*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":1387.1547691367432},{"$f":"E3*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":1610.0319714585394},{"$f":"F3*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":1832.9091737803353},{"$f":"G3*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2055.7863761021317},{"$f":"H3*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2278.6635784239274},{"$f":"I3*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2501.5407807457241},{"$f":"J3*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2724.4179830675207},{"$f":"K3*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2947.2951853893169},{"$f":"L3*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3170.1723877111135},{"$f":"M3*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3393.0495900329101},{"$f":"N3*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3615.9267923547068},{"$f":"O3*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3838.8039946765025},{"$f":"P3*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":4061.6811969982991},{"$f":"Q3*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":4284.5583993200962},{"$f":"R3*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":4507.4356016418924},{"$f":"S3*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":4730.3128039636867}]
[null,"AET 2",{"$f":"C4*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":1782.7388369534394},{"$f":"D4*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":1990.6427835509051},{"$f":"E4*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2310.4837301354041},{"$f":"F4*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2630.3246767199034},{"$f":"G4*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2950.1656233044032},{"$f":"H4*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3270.0065698889025},{"$f":"I4*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3589.8475164734023},{"$f":"J4*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3909.688463057902},{"$f":"K4*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":4229.5294096424022},{"$f":"L4*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":4549.370356226902},{"$f":"M4*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":4869.2113028114009},{"$f":"N4*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":5189.0522493958997},{"$f":"O4*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":5508.8931959804013},{"$f":"P4*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":5828.7341425649001},{"$f":"Q4*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":6148.5750891494008},{"$f":"R4*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":6468.4160357338988},{"$f":"S4*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":6788.2569823183958}]
[null,"AET 3",{"$f":"C5*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2115.2974171752558},{"$f":"D5*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2361.9845213894146},{"$f":"E5*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2741.4897602909609},{"$f":"F5*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3120.9949991925073},{"$f":"G5*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3500.5002380940541},{"$f":"H5*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3880.0054769956005},{"$f":"I5*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":4259.5107158971477},{"$f":"J5*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":4639.015954798695},{"$f":"K5*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":5018.5211937002414},{"$f":"L5*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":5398.0264326017896},{"$f":"M5*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":5777.5316715033359},{"$f":"N5*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":6157.0369104048823},{"$f":"O5*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":6536.5421493064296},{"$f":"P5*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":6916.0473882079777},{"$f":"Q5*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":7295.5526271095241},{"$f":"R5*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":7675.0578660110714},{"$f":"S5*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":8054.5631049126141}]
[null,"AET 4",{"$f":"C6*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":9039.5092876997369},{"$f":"D6*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":10093.701644572873},{"$f":"E6*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":11715.478849010793},{"$f":"F6*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":13337.256053448711},{"$f":"G6*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":14959.033257886631},{"$f":"H6*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":16580.810462324553},{"$f":"I6*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":18202.587666762476},{"$f":"J6*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":19824.364871200396},{"$f":"K6*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":21446.14207563832},{"$f":"L6*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":23067.919280076239},{"$f":"M6*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":24689.696484514159},{"$f":"N6*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":26311.473688952079},{"$f":"O6*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":27933.250893390003},{"$f":"P6*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":29555.028097827922},{"$f":"Q6*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":31176.805302265842},{"$f":"R6*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":32798.582506703766},{"$f":"S6*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":34420.359711141675}]
[]
[{"$f":"Dashboard!O4","v":"Full Policy"},"Total AET Outpuut",{"$f":"SUM(C51:C54)","v":14179.825020718179},15833.483718649935,17291.085359719236,18748.687000788534,20206.288641857827,21663.890282927125,23121.491923996426,24579.093565065719,26036.695206135017,27494.296847204318,28951.898488273611,30409.500129342912,31867.10177041221,33324.703411481503,34782.305052550801,36239.906693620098,37697.50833468941]
[null,"Abet 1",{"$f":"C19*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":1242.2794788897472},{"$f":"D19*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":1387.1547691367432},{"$f":"E19*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":1765.8966387112446},{"$f":"F19*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2144.638508285746},{"$f":"G19*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2523.3803778602473},{"$f":"H19*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2902.1222474347487},{"$f":"I19*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3280.8641170092492},{"$f":"J19*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3659.6059865837506},{"$f":"K19*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":4038.3478561582515},{"$f":"L19*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":4417.0897257327533},{"$f":"M19*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":4795.8315953072533},{"$f":"N19*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":5174.5734648817552},{"$f":"O19*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":5553.3153344562561},{"$f":"P19*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":5932.057204030757},{"$f":"Q19*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":6310.7990736052579},{"$f":"R19*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":6689.5409431797589},{"$f":"S19*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":7068.2828127542634}]
[null,"Abet 2",{"$f":"C20*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":1782.7388369534394},{"$f":"D20*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":1990.6427835509051},{"$f":"E20*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2486.2250702256683},{"$f":"F20*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2981.8073569004309},{"$f":"G20*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3477.3896435751935},{"$f":"H20*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3972.9719302499566},{"$f":"I20*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":4468.5542169247192},{"$f":"J20*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":4964.1365035994822},{"$f":"K20*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":5459.7187902742453},{"$f":"L20*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":5955.3010769490074},{"$f":"M20*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":6450.8833636237705},{"$f":"N20*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":6946.4656502985335},{"$f":"O20*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":7442.0479369732966},{"$f":"P20*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":7937.6302236480587},{"$f":"Q20*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":8433.2125103228227},{"$f":"R20*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":8928.7947969975849},{"$f":"S20*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":9424.3770836723506}]
[null,"Abet 3",{"$f":"C21*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2115.2974171752558},{"$f":"D21*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2361.9845213894146},{"$f":"E21*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2466.3071389543525},{"$f":"F21*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2570.6297565192899},{"$f":"G21*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2674.9523740842274},{"$f":"H21*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2779.2749916491653},{"$f":"I21*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2883.5976092141027},{"$f":"J21*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2987.9202267790411},{"$f":"K21*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3092.2428443439785},{"$f":"L21*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3196.5654619089164},{"$f":"M21*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3300.8880794738538},{"$f":"N21*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3405.2106970387922},{"$f":"O21*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3509.5333146037297},{"$f":"P21*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3613.8559321686676},{"$f":"Q21*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3718.1785497336055},{"$f":"R21*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3822.5011672985434},{"$f":"S21*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3926.8237848634794}]
[null,"Abet 4",{"$f":"C22*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":9039.5092876997369},{"$f":"D22*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":10093.701644572873},{"$f":"E22*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":10572.65651182797},{"$f":"F22*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":11051.611379083066},{"$f":"G22*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":11530.566246338161},{"$f":"H22*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":12009.521113593257},{"$f":"I22*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":12488.475980848354},{"$f":"J22*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":12967.430848103448},{"$f":"K22*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":13446.385715358543},{"$f":"L22*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":13925.34058261364},{"$f":"M22*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":14404.295449868734},{"$f":"N22*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":14883.250317123831},{"$f":"O22*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":15362.205184378927},{"$f":"P22*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":15841.160051634022},{"$f":"Q22*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":16320.114918889118},{"$f":"R22*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":16799.069786144213},{"$f":"S22*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":17278.024653399312}]
[]
[{"$f":"Dashboard!P4","v":"Mixed"},"Total AET Outpuut",{"$f":"SUM(C57:C60)","v":14179.825020718179},15240.677401175099,16301.529781632016,17362.382162088932,18423.234542545852,19484.086923002771,20544.939303459687,21605.79168391661,22666.644064373526,23727.496444830449,24788.348825287365,25849.201205744284,26910.053586201204,27970.905966658123,29031.758347115043,30092.610727571962,31153.463108028875]
[null,"Abet 1",{"$f":"C27*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":1242.2794788897472},{"$f":"D27*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":1532.7767412900894},{"$f":"E27*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":1823.2740036904313},{"$f":"F27*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2113.7712660907737},{"$f":"G27*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2404.2685284911158},{"$f":"H27*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2694.7657908914575},{"$f":"I27*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2985.2630532917997},{"$f":"J27*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3275.7603156921414},{"$f":"K27*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3566.2575780924831},{"$f":"L27*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3856.7548404928252},{"$f":"M27*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":4147.252102893166},{"$f":"N27*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":4437.7493652935082},{"$f":"O27*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":4728.2466276938503},{"$f":"P27*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":5018.7438900941925},{"$f":"Q27*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":5309.2411524945337},{"$f":"R27*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":5599.7384148948768},{"$f":"S27*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":5890.2356772952207}]
[null,"Abet 2",{"$f":"C28*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":1782.7388369534394},{"$f":"D28*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2039.4573894748009},{"$f":"E28*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2296.1759419961622},{"$f":"F28*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2552.8944945175235},{"$f":"G28*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2809.6130470388853},{"$f":"H28*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3066.3315995602466},{"$f":"I28*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3323.0501520816078},{"$f":"J28*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3579.7687046029691},{"$f":"K28*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3836.4872571243309},{"$f":"L28*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":4093.2058096456922},{"$f":"M28*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":4349.9243621670539},{"$f":"N28*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":4606.6429146884147},{"$f":"O28*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":4863.3614672097765},{"$f":"P28*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":5120.0800197311382},{"$f":"Q28*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":5376.7985722524991},{"$f":"R28*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":5633.5171247738608},{"$f":"S28*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":5890.2356772952207}]
[null,"Abet 3",{"$f":"C29*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2115.2974171752558},{"$f":"D29*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2273.5517184170553},{"$f":"E29*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2431.8060196588544},{"$f":"F29*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2590.060320900654},{"$f":"G29*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2748.3146221424536},{"$f":"H29*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":2906.5689233842531},{"$f":"I29*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3064.8232246260527},{"$f":"J29*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3223.0775258678527},{"$f":"K29*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3381.3318271096523},{"$f":"L29*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3539.5861283514523},{"$f":"M29*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3697.8404295932519},{"$f":"N29*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":3856.0947308350515},{"$f":"O29*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":4014.3490320768506},{"$f":"P29*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":4172.6033333186506},{"$f":"Q29*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":4330.8576345604506},{"$f":"R29*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":4489.1119358022497},{"$f":"S29*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":4647.3662370440479}]
[null,"Abet 4",{"$f":"C30*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":9039.5092876997369},{"$f":"D30*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":9394.8915519931525},{"$f":"E30*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":9750.273816286568},{"$f":"F30*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":10105.656080579982},{"$f":"G30*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":10461.038344873397},{"$f":"H30*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":10816.420609166813},{"$f":"I30*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":11171.802873460229},{"$f":"J30*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":11527.185137753646},{"$f":"K30*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":11882.567402047061},{"$f":"L30*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":12237.949666340479},{"$f":"M30*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":12593.331930633893},{"$f":"N30*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":12948.714194927308},{"$f":"O30*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":13304.096459220726},{"$f":"P30*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":13659.478723514141},{"$f":"Q30*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":14014.860987807559},{"$f":"R30*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":14370.243252100974},{"$f":"S30*(1-'Enrol Scenarios'!$B$18)*'Enrol Scenarios'!$B$13","v":14725.625516394384}]
[]
["Enrolments excl. Occupational"]
["Status quo Scenario",null,{"$f":"C2-C8","v":255004.99100000001},{"$f":"D2-D8","v":284743.80800000002},330494.22080000001,376244.6336,421995.04639999999,467745.45919999992,513495.87199999997,559246.28480000002,604996.69760000007,650747.11040000012,696497.52320000017,742247.93600000022,787998.34880000027,833748.76160000032,879499.17440000037,925249.58720000042,{"$f":"S2-S8","v":971000}]
["Full Policy Scenario",null,{"$f":"C18-C24","v":255004.99100000001},{"$f":"D18-D24","v":284743.80800000002},309094.22080000001,333444.63359999994,357795.04639999999,382145.45919999992,406495.87199999997,430846.28480000002,455196.69760000007,479547.11040000012,503897.52320000017,528247.93600000022,552598.34880000027,576948.76160000032,601299.17440000037,625649.58720000042,{"$f":"S18-S24","v":650000}]
["Balanced Scenario",null,{"$f":"C26-C32","v":256027.76636727626},{"$f":"D26-D32","v":275348.09346932149},294491.55390470009,305126.29944126343,317248.31287758588,330958.4065568737,346364.22624390066,363580.71431878791,382730.60436771676,403944.94929877081,427363.68525536073,453136.23375371983,481422.14463543525,512391.78260160342,546227.06028272863,583122.22099872446,{"$f":"S26-S32","v":562500}]
[]
[null,null,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,{"$f":"Dashboard!N4","v":"Status quo"},{"$f":"C2","v":262621},{"$f":"D2","v":293248},340364.79999999999,387481.59999999998,434598.39999999997,481715.19999999995,528832,575948.80000000005,623065.60000000009,670182.40000000014,717299.20000000019,764416.00000000023,811532.80000000028,858649.60000000033,905766.40000000037,952883.20000000042,1000000]
[null,{"$f":"Dashboard!O4","v":"Full Policy"},{"$f":"C18","v":262621},{"$f":"D18","v":293248},340364.79999999999,387481.59999999998,434598.39999999997,481715.19999999995,528832,575948.80000000005,623065.60000000009,670182.40000000014,717299.20000000019,764416.00000000023,811532.80000000028,858649.60000000033,905766.40000000037,952883.20000000042,1000000]
[null,{"$f":"Dashboard!P4","v":"Mixed"},{"$f":"C26","v":262621},{"$f":"D26","v":293248},323698.13333333336,345639.55176785146,369068.23810212867,394085.00467937125,420797.49726435298,449320.65823719499,479777.2211840786,512298.23901308741,547023.6478676321,584102.86926394596,623695.45304361614,665971.76390773908,711113.71448681911,759315.54810076964,750000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Programme Name","Theory Cost per enrolment (2014 prices)","Practical Cost per enrolment (2014 prices)","Proportion with practical component","Average Total Cost per Enrolment","FTE to Enrol ratio","Cost per FTE"]
["Skills Programme",5000,10000,1,{"$f":"B84+D84*C84","v":15000},0.2,{"$f":"E84/F84","v":75000}]
["AET",null,null,0,null,0.93]
["Matric",null,null,0,null,0.93]
[]
[]
[null,null,"2014",2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,"2030"]
["Status Quo FTE","Total Enrolment",{"$f":"SUM(C91:C96)","v":239629.02452156699},267574.688173834,310566.50079574069,353558.31341764744,396550.12603955413,439541.93866146088,482533.75128336763,525525.56390527438,568517.37652718113,611509.18914908799,654501.00177099474,697492.81439290149,740484.62701480824,783476.43963671487,826468.25225862185,869460.0648805286,912451.87750243477]
[null,"FTE Abet 1",{"$f":"C3*$F$85","v":14710.615737594537},16426.175529824817,19065.405216655246,21704.634903485672,24343.864590316101,26983.094277146531,29622.323963976964,32261.5536508074,34900.783337637826,37540.013024468266,40179.242711298692,42818.472398129124,45457.702084959557,48096.93177178999,50736.161458620423,53375.391145450856,56014.620832281267]
[null,"FTE Abet 2",{"$f":"C4*$F$85","v":21110.536265435439},23572.45817648403,27359.896786158304,31147.335395832579,34934.774005506857,38722.212615181139,42509.651224855421,46297.089834529703,50084.528444203985,53871.967053878259,57659.405663552541,61446.844273226816,65234.282882901105,69021.72149257538,72809.160102249676,76596.598711923943,80384.037321598196]
[null,"FTE Abet 3",{"$f":"C5*$F$85","v":25048.572405463576},27969.750175185469,32463.711344755855,36957.672514326252,41451.633683896645,45945.594853467039,50439.556023037425,54933.517192607826,59427.478362178226,63921.439531748627,68415.400701319013,72909.361870889406,77403.323040459814,81897.284210030208,86391.245379600616,90885.206549171009,95379.167718741359]
[null,"FTE Abet 4",{"$f":"C6*$F$85","v":107042.53740600466},119525.89476559777,138730.38270240114,157934.87063920451,177139.35857600789,196343.84651281126,215548.33444961469,234752.82238641806,253957.31032322149,273161.79826002487,292366.28619682824,311570.77413363167,330775.26207043504,349979.75000723841,369184.23794404184,388388.72588084528,407593.21381764841]
[null,"FTE Grade 12",{"$f":"C7*$F$85","v":70193.56090706875},78379.571126741939,90972.98890577018,103566.40668479842,116159.82446382666,128753.24224285492,141346.66002188317,153940.07780091141,166533.49557993968,179126.91335896793,191720.33113799617,204313.74891702444,216907.16669605271,229500.58447508095,242094.00225410922,254687.42003313749,267280.83781216561]
[null,"FTE Skills Programmes",{"$f":"C8*$F$84","v":1523.2018},{"$f":"D8*$F$84","v":1700.8384000000003},1974.1158400000002,2247.3932799999998,2520.6707200000001,2793.9481599999999,3067.2256000000002,3340.5030400000005,3613.7804800000008,3887.0579200000011,4160.3353600000009,4433.6128000000017,4706.8902400000024,4980.1676800000023,5253.445120000003,5526.7225600000029,5800]
[]
["Full Policy FTE","Total Enrolment",{"$f":"SUM(C99:C104)","v":239629.02452156699},267574.688173834,294703.0422955784,321831.39641732286,348959.7505390672,376088.1046608116,403216.458782556,430344.8129043004,457473.1670260448,484601.52114778914,511729.8752695336,538858.229391278,565986.58351302228,593114.9376347668,620243.2917565112,647371.64587825548,674500]
[null,"FTE Abet 1",{"$f":"C19*$F$85","v":14710.615737594537},16426.175529824817,20911.09716116983,25396.018792514842,29880.940423859854,34365.86205520486,38850.783686549876,43335.705317894885,47820.626949239893,52305.548580584902,56790.470211929911,61275.39184327492,65760.313474619921,70245.235105964937,74730.156737309939,79215.078368654955,83700]
[null,"FTE Abet 2",{"$f":"C20*$F$85","v":21110.536265435439},{"$f":"D20*$F$85","v":23572.45817648403},29440.960964718426,35309.463752952819,41177.966541187212,47046.469329421612,52914.972117656005,58783.474905890398,64651.977694124791,70520.480482359184,76388.983270593584,82257.486058827984,88125.98884706237,93994.49163529677,99862.994423531156,105731.49721176556,{"$f":"S20*$F$85","v":111600}]
[null,"FTE Abet 3",{"$f":"C21*$F$85","v":25048.572405463576},{"$f":"D21*$F$85","v":27969.750175185469},29205.100163506439,30440.450151827408,31675.800140148374,32911.150128469344,34146.500116790317,35381.850105111283,36617.200093432257,37852.550081753223,39087.900070074196,40323.250058395162,41558.600046716136,42793.950035037109,44029.300023358075,45264.650011679048,{"$f":"S21*$F$85","v":46500}]
[null,"FTE Abet 4",{"$f":"C22*$F$85","v":107042.53740600466},{"$f":"D22*$F$85","v":119525.89476559777},125197.50178122459,130869.10879685142,136540.71581247821,142212.32282810504,147883.92984373186,153555.53685935866,159227.14387498549,164898.75089061228,170570.35790623911,176241.9649218659,181913.57193749273,187585.17895311955,193256.78596874635,198928.39298437317,{"$f":"S22*$F$85","v":204600}]
[null,"FTE Grade 12",{"$f":"C23*$F$85","v":70193.56090706875},{"$f":"D23*$F$85","v":78379.571126741939},83694.266384959148,89008.961643176342,94323.656901393551,99638.35215961076,104953.04741782795,110267.74267604516,115582.43793426237,120897.13319247958,126211.82845069678,131526.523708914,136841.21896713119,142155.91422534839,147470.60948356558,152785.30474178278,{"$f":"S23*$F$85","v":158100}]
[null,"FTE Occupational ",{"$f":"C24*$F$84","v":1523.2018},1700.8384000000003,6254.1158400000004,10807.393280000002,15360.670720000002,19913.94816,24467.225600000002,29020.50304,33573.780480000001,38127.057919999999,42680.335359999997,47233.612800000003,51786.890240000001,56340.167680000006,60893.445120000004,65446.722560000002,70000]
[]
["Mixed  FTE","Total Enrolment",{"$f":"SUM(C107:C112)","v":239424.46944811172},259499.50260760472,279574.53576709772,299649.56892659073,319724.60208608367,339799.63524557685,359874.66840506985,379949.70156456286,400024.73472405586,420099.76788354886,440174.80104304192,460249.83420253493,480324.86736202799,500399.90052152105,520474.93368101405,540549.96684050711,560625]
[null,"FTE Abet 1",{"$f":"C27*$F$85","v":14710.615737594537},18150.577253994878,21590.538770395222,25030.500286795563,28470.461803195907,31910.423319596248,35350.384835996585,38790.346352396926,42230.307868797267,45670.2693851976,49110.230901597941,52550.192417998282,55990.153934398622,59430.115450798963,62870.076967199297,66310.038483599637,{"$f":"S27*$F$85","v":69750}]
[null,"FTE Abet 2",21110.536265435439,{"$f":"D28*$F$85","v":24150.502748845724},27190.469232256011,30230.435715666299,33270.402199076583,36310.368682486871,39350.335165897159,42390.301649307446,45430.268132717734,48470.234616128022,51510.20109953831,54550.167582948598,57590.134066358885,60630.100549769173,63670.067033179454,66710.033516589741,{"$f":"S28*$F$85","v":69750}]
[null,"FTE Abet 3",25048.572405463576,26922.561514959489,28796.550624455398,30670.539733951307,32544.52884344722,34418.517952943133,36292.50706243905,38166.496171934959,40040.485281430876,41914.474390926785,43788.463500422702,45662.452609918611,47536.441719414528,49410.430828910437,51284.419938406354,53158.409047902263,{"$f":"S29*$F$85","v":55032.398157398158}]
[null,"FTE Abet 4",107042.53740600466,111250.84320096874,115459.14899593283,119667.45479089691,123875.760585861,128084.06638082511,132292.37217578921,136500.67797075331,140708.98376571742,144917.28956068153,149125.59535564561,153333.90115060972,157542.20694557382,161750.51274053793,165958.81853550201,170167.12433046612,{"$f":"S30*$F$85","v":174375.43012543014}]
[null,"FTE Grade 12",70193.56090706875,75445.036582700181,80696.512258331612,85947.987933963042,91199.463609594473,96450.939285225904,101702.41496085734,106953.89063648877,112205.3663121202,117456.84198775163,122708.31766338307,127959.79333901452,133211.26901464595,138462.74469027741,143714.22036590884,148965.6960415403,{"$f":"S31*$F$85","v":154217.17171717173}]
[null,"FTE Occupational ",{"$f":"C32*$F$84","v":1318.6467265447463},3579.9813061356999,5841.3158857266535,8102.6504653176062,10363.985044908559,12625.319624499512,14886.654204090464,17147.988783681416,19409.323363272368,21670.657942863323,23931.992522454275,26193.327102045227,28454.661681636178,30715.996261227134,32977.330840818082,35238.665420409037,37500]

{"sheet":"Enrol Scenarios","index":5,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Learning Programme Mix",{"$f":"Dashboard!N4","v":"Status quo"},{"$f":"Dashboard!O4","v":"Full Policy"},{"$f":"Dashboard!P4","v":"Mixed"},null,null,null,{"$f":"Dashboard!N4","v":"Status quo"},{"$f":"Dashboard!O4","v":"Full Policy"},{"$f":"Dashboard!P4","v":"Mixed"},"Norm"]
["AET Level 1",6.0230775088474471E-2,0.09,0.1,null,null,"AET Level 1",null,{"$f":"C4*K4","v":1.7999999999999998},{"$f":"D4*K4","v":2},20]
["AET Level 2",8.6434448732901278E-2,0.12,0.1,null,null,"AET Level 2",null,2.4,2,20]
["AET Level 3",0.10255824485886167,0.05,{"$f":"(100%-$D$9)*$B6/SUM($B$4:$B$8)","v":7.8899495566162228E-2},null,null,"AET Level 3",null,1,1.5779899113232445,20]
["AET Level 4",0.43827227292220261,{"$f":"100%-C8-C9-C6-C5-C4","v":0.22},{"$f":"100%-D8-D9-D6-D5-D4","v":0.25000061666728335},null,null,"AET Level 4",null,5.5,6.2500154166820838,25]
["NSC / NASCA",0.28739875033566192,0.17,{"$f":"(100%-$D$9)*$B8/SUM($B$4:$B$8)","v":0.22109988776655445},null,null,"Grade 12",null,5.1000000000000005,6.6329966329966332,30]
["Skills Programmes",{"$f":"Dashboard!E7","v":2.9000000000000001E-2},{"$f":"Dashboard!F7","v":0.35},{"$f":"Dashboard!G7","v":0.25},null,null,"Skills Programmes",null,10.5,7.5,30]
[null,null,null,null,null,null,"Average Lecturer Ratio",null,{"$f":"SUM(I4:I9)","v":26.3},{"$f":"SUM(J4:J9)","v":25.961001961001962}]
[]
["Certification",{"$f":"Dashboard!N4","v":"Status quo"},{"$f":"Dashboard!O4","v":"Full Policy"},{"$f":"Dashboard!P4","v":"Mixed"}]
["AET Level 1 to 4",{"$f":"Dashboard!E8","v":0.17452550154948801},{"$f":"Dashboard!F8","v":0.2},{"$f":"Dashboard!G8","v":0.17452550154948801}]
["Grade 12",0.38233333333333325,0.38233333333333325,0.38233333333333325]
["Skills Programmes",0.8,0.8,0.8]
[]
["Dropout Rates"]
["AET Level 1 to 4",0.55000000000000004,0.55000000000000004,0.55000000000000004]
["Grade 12",0.55000000000000004,0.55000000000000004,0.55000000000000004]
["Skills Programmes",0.04,0.04,0.04]
[]
[]
["Number of colleges",9,9,9]
["Number of AET Centres",3150]
["Total Number of employees",{"$f":"B27+B28+B29","v":19133}]
["FTE lecturers"]
["Number of Support Staff",283]
["Number of Educators",16604]
["Number of Centre Managers",2246]
["Number of learners",293248]
["Lecturer Student Ratio",18]

{"sheet":"Funding Descr","index":6,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Model Layout"]
[null,null,"This model forms part of the broader post school education and training (PSET) system costing initiative\n\n"]
[null,null,"'This model forecasts  expenditure of the Community Colleges up to 2030 based on the targets and objectives of White Paper on Post-School Education."]

{"sheet":"Funding Dashboard","index":7,"n_rows":15,"n_cols":16,"rows_kept":15,"cut":false,"hidden":false,"merged":[[10,2,11,7],[1,2,2,7],[5,2,6,2],[1,11,2,11],[2,12,2,14]]}
[]
[null,null,"INPUTS & ASSUMPTIONS",null,null,null,null,null,null,null,null,"OUTPUTS"]
[null,null,null,null,null,null,null,null,null,null,null,null,2030]
[null,null,null,null,null,null,null,null,null,null,null,null,"Status quo","Full Policy","Mixed",2014]
[null,null,null,null,"Status quo","Full Policy","Mixed",null,null,null,null,"Total current spending (R'm)",{"$f":"Dashboard!N5","v":14163.289965590888},{"$f":"Dashboard!O5","v":17956.347603402424},{"$f":"Dashboard!P5","v":12283.744322448772},{"$f":"Dashboard!Q5","v":1843.8189689996782}]
[null,null,"Government Subsidy","Historical Real Growth",1.6E-2,1.6E-2,1.6E-2,null,null,null,null,"Total Current Revenue",{"$f":"'Funding Shortfall'!C8","v":7385.3231429522202},{"$f":"'Funding Shortfall'!D8","v":9962.4486400209735},{"$f":"'Funding Shortfall'!E8","v":7361.7964998901416},{"$f":"'Funding Shortfall'!B8","v":1843.8189689999999}]
[null,null,null,"Projection Real Growth",2.9000000000000001E-2,2.9000000000000001E-2,2.9000000000000001E-2,null,null,null,null,"Shortfall (-) / Surplus (+): \nCurrent spending",{"$f":"M6-M5","v":-6777.9668226386675},{"$f":"N6-N5","v":-7993.8989633814508},{"$f":"O6-O5","v":-4921.9478225586308}]
[null,null,"Learning Fees","Real Growth",0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,"Total Cumulative Spending (R'm)",{"$f":"Dashboard!N6","v":125713},{"$f":"Dashboard!O6","v":341249},{"$f":"Dashboard!P6","v":203685}]
[null,null,null,null,null,null,null,null,null,null,null,"Total Cumulative Revenue (R'm)",{"$f":"('Funding over time'!S3+'TVET & CET Funding'!T10)/1000","v":77800.07562569424},{"$f":"('Funding over time'!S3+'TVET & CET Funding'!T21)/1000","v":77800.07562569424},{"$f":"('Funding over time'!S3+'TVET & CET Funding'!T32)/1000","v":77800.07562569424}]
[null,null,null,null,null,null,null,null,null,null,null,"Shortfall (-) / Surplus (+): \nCurrent spending",{"$f":"M10-M9","v":-47912.92437430576},{"$f":"N10-N9","v":-263448.92437430576},{"$f":"O10-O9","v":-125884.92437430576}]
[]
[]
[null,null,null,null,"Status quo","Full Policy","Mixed"]
[null,null,"Enrolments","Current",{"$f":"Dashboard!E6:E6","v":1000000},{"$f":"Dashboard!F6:F6","v":1000000},{"$f":"Dashboard!G6:G6","v":750000}]

{"sheet":"Funding Shortfall","index":8,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[[3,2,3,4],[4,2,4,4],[4,5,4,7],[13,2,13,4],[14,2,14,4],[14,5,14,7]]}
[]
[]
[]
[null,null,"Historical"]
["All figures in R'm",2014,"2030 (Nominal)",null,null,"2030 (Real)"]
[null,"Status Quo","Status Quo","Full Policy Scenario","Mixed","Status Quo","Full Policy Scenario","Mixed"]
["Current Costs",{"$f":"Dashboard!Q5","v":1843.8189689996782},{"$f":"Dashboard!N5","v":14163.289965590888},{"$f":"Dashboard!O5","v":17956.347603402424},{"$f":"Dashboard!P5","v":12283.744322448772},{"$f":"C7/(1.062)^16","v":5409.6837704338914},{"$f":"D7/(1.062)^16","v":6858.4461973445887},{"$f":"E7/(1.062)^16","v":4691.7892991494837}]
["Funding and financing: Total",{"$f":"B9+B10+B11","v":1843.8189689999999},{"$f":"C9+C10+C11","v":7385.3231429522202},9962.4486400209735,7361.7964998901416,2820.8320837108308,3805.1679272707897,2811.8460571975766]
["   State subsidies",{"$f":"'Funding over time'!B15/1000","v":1731.89},{"$f":"'Funding over time'!R4/1000","v":6868.4723256918614},{"$f":"C9","v":6868.4723256918614},{"$f":"C9","v":6868.4723256918614},{"$f":"C9/(1.062)^16","v":2623.4203605404646},{"$f":"D9/(1.062)^16","v":2623.4203605404646},2623.4203605404646]
["   NSF",{"$f":"'Funding over time'!B19/1000","v":22.5958058527468},{"$f":"'Funding over time'!R19/1000","v":103.75909492945411},{"$f":"'Funding over time'!R20/1000","v":2319.6390809594436},{"$f":"'Funding over time'!R21/1000","v":231.96390809594439},{"$f":"C10/(1.062)^16","v":39.630897428382909},885.98863117372957,88.598863117372971]
["   SETA",{"$f":"'Funding over time'!B16/1000","v":89.333163147253217},{"$f":"'Funding over time'!R16/1000","v":413.09172233090385},{"$f":"'Funding over time'!R17/1000","v":774.33723336966841},{"$f":"'Funding over time'!R18/1000","v":261.36026610233637},{"$f":"C11/(1.062)^16","v":157.78082574198314},295.75893555659582,99.826833539738644]
["Shortfall (+) / Surplus (-)",{"$f":"B7-B8","v":-3.2173375075217336E-10},6777.9668226386675,7993.8989633814508,4921.9478225586308,2588.8516867230605,3053.2782700737989,1879.9432419519071]
[null,null,{"$f":"C12/C8","v":0.91776171352865576},0.80240302883655534,0.66857971727853116,0.91776171352865576,0.80240302883655534,0.66857971727853072]
[null,null,"Projected"]
["All figures in R'm",2014,2030,null,null,"2030 (Real)"]
[null,"Status Quo","Status Quo","Full Policy Scenario","Mixed","Status Quo","Full Policy Scenario","Mixed"]
["Current Costs",{"$f":"B7","v":1843.8189689996782},14163.289965590888,17956.347603402424,12283.744322448772,5409.6837704338914,6858.4461973445887,4691.7892991494837]
["Funding and financing: Total",{"$f":"B19+B20+B21","v":1843.8189689999999},7371.625927575551,9880.4542645988477,7348.7227709941944,2815.6004176287747,3773.8500877670058,2806.85253244455]
["   State subsidies",{"$f":"'Funding over time'!B4/1000","v":1731.89},{"$f":"('Funding over time'!R15)/1000","v":6868.4723256918614},{"$f":"C19","v":6868.4723256918614},{"$f":"C19","v":6868.4723256918614},{"$f":"C19/(1.062)^16","v":2623.4203605404646},{"$f":"D19/(1.062)^16","v":2623.4203605404646},2623.4203605404646]
["   NSF",{"$f":"'Funding over time'!B8/1000","v":22.5958058527468},{"$f":"'Funding over time'!R8/1000","v":101.00934466675686},{"$f":"'Funding over time'!R9/1000","v":2258.1656440856186},{"$f":"'Funding over time'!R10/1000","v":225.81656440856187},{"$f":"C20/(1.062)^16","v":38.58062737071986},862.50878612522433,86.250878612522428]
["   SETA",{"$f":"'Funding over time'!B16/1000","v":89.333163147253217},{"$f":"'Funding over time'!R5/1000","v":402.14425721693237},{"$f":"'Funding over time'!R6/1000","v":753.81629482136896},{"$f":"'Funding over time'!R7/1000","v":254.43388089377081},{"$f":"C21/(1.062)^16","v":153.59942971759043},287.92094110131706,97.181293291563165]
["Shortfall (+) / Surplus (-)",{"$f":"B17-B18","v":-3.2173375075217336E-10},6791.6640380153367,8075.8933388035766,4935.021551454578,2594.0833528051166,3084.5961095775829,1884.9367667049337]
[null,null,{"$f":"C22/C18","v":0.92132510585070371},0.81736053045041479,0.67154820031221951,0.92132510585070382,0.81736053045041446,0.67154820031221962]
[]
[null,null,65165337.68745666,1160478616.3519681]
[null,null,171962971.11560988,311981026.14745873]

{"sheet":"Funding over time","index":9,"n_rows":54,"n_cols":39,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Projection"]
["Funding Item",2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,"Cumulative"]
["Total revenue",{"$f":"SUM(B4:B8)","v":2022485.2952945065},{"$f":"SUM(C4:C8)","v":2332748.2994924649},2557536.5661864597,2803541.5211000172,2945735.6163717778,3214884.2509104828,3507438.7177433367,3826615.6410579802,4174837.6643942562,4554747.8918541344,4969229.950012859,5421429.8754640296,5914779.9941312568,6453024.9735972006,7040250.2461945461,7680913.0185982492,8379876.1032906901,{"$f":"SUM(B3:R3)","v":77800075.625694245}]
["Programme funding (DHET Subsidy)",1731890,1859897,{"$f":"C4*(1+$B$26)/(1+$C$27)","v":2029147.6269999999},{"$f":"D4*(1+$B$26)/(1+$C$27)","v":2213800.061057},{"$f":"E4*(1+$B$26)/(1+$C$27)","v":2415255.8666131869},{"$f":"F4*(1+$B$26)/(1+$C$27)","v":2635044.150474987},{"$f":"G4*(1+$B$26)/(1+$C$27)","v":2874833.1681682109},{"$f":"H4*(1+$B$26)/(1+$C$27)","v":3136442.9864715179},{"$f":"I4*(1+$B$26)/(1+$C$27)","v":3421859.298240426},{"$f":"J4*(1+$B$26)/(1+$C$27)","v":3733248.4943803046},{"$f":"K4*(1+$B$26)/(1+$C$27)","v":4072974.1073689121},{"$f":"L4*(1+$B$26)/(1+$C$27)","v":4443614.7511394834},{"$f":"M4*(1+$B$26)/(1+$C$27)","v":4847983.6934931763},{"$f":"N4*(1+$B$26)/(1+$C$27)","v":5289150.2096010549},{"$f":"O4*(1+$B$26)/(1+$C$27)","v":5770462.8786747511},{"$f":"P4*(1+$B$26)/(1+$C$27)","v":6295575.0006341534},{"$f":"Q4*(1+$B$26)/(1+$C$27)","v":6868472.3256918611},{"$f":"SUM(B4:R4)","v":63639651.619009025}]
["SETA: Status Quo",89333.163147253217,{"$f":"$B$30*C39","v":100928.8357902726},{"$f":"$B$30*D39","v":112789.06270827298},{"$f":"$B$30*E39","v":125885.52007484178},{"$f":"$B$30*F39","v":140980.56989364186},{"$f":"$B$30*G39","v":154279.99449933658},{"$f":"$B$30*H39","v":168319.47399877623},{"$f":"$B$30*I39","v":183636.54613266487},{"$f":"$B$30*J39","v":200347.47183073737},{"$f":"$B$30*K39","v":218579.09176733452},{"$f":"$B$30*L39","v":238469.78911816195},{"$f":"$B$30*M39","v":260170.53992791465},{"$f":"$B$30*N39","v":283846.05906135484},{"$f":"$B$30*O39","v":309676.05043593817},{"$f":"$B$30*P39","v":337856.57102560851},{"$f":"$B$30*Q39","v":368601.51898893889},{"$f":"$B$30*R39","v":402144.25721693237},{"$f":"SUM(B5:R5)","v":3695844.515617982}]
["SETA: Full Policy",89333.163147253217,{"$f":"$C$30*C40","v":230986.42522784928},{"$f":"$C$30*D40","v":258129.82182733782},288102.46390297561,264708.73650000006,289196.65451249998,315513.55007313751,344225.28312979307,375549.78389460425,409724.81422901328,447009.77232385345,487687.66160532396,532067.23881140852,580485.3575432467,633309.52507968212,690940.6918619331,753816.294821369,6990787.2384912819]
["SETA: Mixed",89333.163147253217,{"$f":"$D$30*C41","v":115493.21261392464},{"$f":"$D$30*D41","v":129064.91091366891},144051.2319514878,89271.131250000006,97611.881906249982,106494.56315971875,116185.56840725316,126758.45513231319,138293.47454935373,150878.18073334487,164608.09518007925,179587.43184146646,195929.88813903992,213759.50795969256,233211.62318402456,254433.88089377081,2544966.2009626417]
["NSF: Status Quo",22595.805852746798,{"$f":"$B$31*C43","v":25442.825860418998},{"$f":"$B$31*D43","v":28405.143737180188},31702.244113712339,35519.312114948865,38751.569517409211,42277.962343493447,46125.256916751357,50322.655296175726,54902.016928127719,59898.100468587356,65348.827611228779,71295.57092385061,77783.467877921008,84861.763454811822,92584.183929199702,101009.34466675686,928826.05161332083]
["NSF: Full Policy",22595.805852746798,{"$f":"$C$31*C44","v":568800},{"$f":"$C$31*D44","v":635025.6},708735.60000000009,794070,866330.37,945166.43366999994,1031176.5791339701,1125013.6478351613,1227389.889788161,1339082.369758884,1460938.8654069419,1593884.3021589736,1738927.7736554402,1897170.2010580853,2069812.689354371,2258165.6440856187,20282285.771758355]
["NSF Mixed",22595.805852746798,{"$f":"$D$31*C45","v":56880},{"$f":"$D$31*D45","v":63502.559999999998},70873.560000000012,79407,86633.037000000011,94516.643366999997,103117.65791339701,112501.36478351614,122738.98897881611,133908.2369758884,146093.88654069419,159388.43021589739,173892.77736554403,189717.02010580854,206981.26893543711,225816.56440856188,2048564.8024433076]
[]
["Historical"]
["Funding Item",2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,"Cumulative",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current",0.18]
["Total revenue",{"$f":"SUM(B15:B19)","v":2022485.2952945065},2344927.9802137041,2571920.7563732956,2819595.8944852403,2960176.7241333085,3230669.0822422286,3524659.9687262708,3845404.0258803619,4195335.792235475,4577111.3493289026,4993628.4821178326,5448048.6739905551,5943821.1033236952,6484708.8237261511,7074817.3266852321,7718625.703413588,8421020.6424242239,{"$f":"SUM(B14:R14)","v":78176957.624594584},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SETA Landscape",1]
["Programme funding (DHET Subsidy)",1731890,1859897,{"$f":"C15*(1+$B$26)/(1+$C$27)","v":2029147.6269999999},{"$f":"D15*(1+$B$26)/(1+$C$27)","v":2213800.061057},{"$f":"E15*(1+$B$26)/(1+$C$27)","v":2415255.8666131869},{"$f":"F15*(1+$B$26)/(1+$C$27)","v":2635044.150474987},{"$f":"G15*(1+$B$26)/(1+$C$27)","v":2874833.1681682109},{"$f":"H15*(1+$B$26)/(1+$C$27)","v":3136442.9864715179},{"$f":"I15*(1+$B$26)/(1+$C$27)","v":3421859.298240426},{"$f":"J15*(1+$B$26)/(1+$C$27)","v":3733248.4943803046},{"$f":"K15*(1+$B$26)/(1+$C$27)","v":4072974.1073689121},{"$f":"L15*(1+$B$26)/(1+$C$27)","v":4443614.7511394834},{"$f":"M15*(1+$B$26)/(1+$C$27)","v":4847983.6934931763},{"$f":"N15*(1+$B$26)/(1+$C$27)","v":5289150.2096010549},{"$f":"O15*(1+$B$26)/(1+$C$27)","v":5770462.8786747511},{"$f":"P15*(1+$B$26)/(1+$C$27)","v":6295575.0006341534},{"$f":"Q15*(1+$B$26)/(1+$C$27)","v":6868472.3256918611},{"$f":"SUM(B15:R15)","v":63639651.619009025}]
["SETA",89333.163147253217,{"$f":"$B$30*C39*(1+$B$25)/(1+$B$26)","v":103676.39438144684},{"$f":"$B$30*D39*(1+$B$25)/(1+$B$26)","v":115859.48907164211},129312.46777990395,144818.44608598025,158479.91735600965,172901.58983540654,188635.63451042853,205801.47725087753,224529.41168070745,244961.58814365178,267253.0926647241,291573.12409721391,318106.27839006047,347053.94972355594,378635.8591483995,413091.72233090387,{"$f":"SUM(B16:R16)","v":3794023.6055981666}]
["SETA: Full Policy",89333.163147253217,{"$f":"$C$30*C40*(1+$B$25)/(1+$B$26)","v":237274.5066478925},{"$f":"$C$30*D40*(1+$B$25)/(1+$B$26)","v":265156.82064335246},295945.39990473399,271914.83134330896,297069.37737136456,324102.6907121588,353596.03556696529,385773.27480355912,420878.64281068306,459178.59930645517,500963.85184334248,546551.56236108672,596287.7545359456,650549.94019871659,709749.98475679976,774337.23336966836,{"$f":"SUM(B17:R17)","v":7178663.669323286}]
["SETA: Mixed",89333.163147253217,{"$f":"$D$30*C41*(1+$B$25)/(1+$B$26)","v":118637.25332394625},{"$f":"$D$30*D41*(1+$B$25)/(1+$B$26)","v":132578.41032167623},147972.69995236699,91701.335281278647,100269.14395264378,109393.63605233438,119348.45693309681,130209.16651400863,142058.20066678346,154985.49692746068,169089.17714785962,184476.29226831481,201263.63486473149,219578.62563742205,239560.28057042742,261360.26610233638,2611815.2396639409]
["NSF",22595.805852746798,{"$f":"$B$31*C43","v":25442.825860418998},{"$f":"$B$31*D43*(1+$B$25)/(1+$B$26)","v":29178.409336624965},{"$f":"$B$31*E43*(1+$B$25)/(1+$B$26)","v":32565.26579123503},36486.244809553798,39806.4930872232,43428.883958160506,47380.912398353117,51692.575426603245,56396.599790424138,61528.69037135275,67127.801195145817,73236.431103904106,79900.946334359367,87171.932450786087,95104.578303807619,103759.09492945411,{"$f":"SUM(B19:R19)","v":952803.49100015382}]
["NSF: Full Policy",22595.805852746798,{"$f":"$B$31*C44","v":25442.825860418998},{"$f":"$C$31*D44*(1+$B$25)/(1+$B$26)","v":652312.73136571958},728029.31890009181,815686.75435380393,889914.24900000007,{"$f":"$C$31*H44*(1+$B$25)/(1+$B$26)","v":970896.44565899996},1059248.0222139691,1155639.5922354404,1260802.7951288654,1375535.8494855925,1500709.6117887807,1637274.1864615597,1786266.1374295617,1948816.3559356518,2126158.644325796,2319639.0809594435,{"$f":"SUM(B20:R20)","v":20274968.406956442}]
["NSF Mixed",22595.805852746798,25442.825860418998,{"$f":"$D$31*D45*(1+$B$25)/(1+$B$26)","v":65231.273136571952},{"$f":"$D$31*E45*(1+$B$25)/(1+$B$26)","v":72802.931890009189},81568.675435380384,88991.424900000013,97089.644565900002,105924.80222139692,115563.95922354404,126080.27951288654,137553.58494855926,150070.96117887806,163727.418646156,178626.61374295616,194881.63559356521,212615.86443257963,231963.90809594438,2070731.6092374937]
[]
[]
["Growth Assumptions"]
["Historical",0.1207,null,null,{"$f":"1843.81896899968*1000","v":1843818.9689996799}]
["Projection",9.0999999999999998E-2]
["CPI Inflation","Nominal",{"$f":"IF(B27=Dashboard!AK3,Dashboard!AL4,Dashboard!AL3)","v":0}]
[]
["Community College Allocations","Status Quo","Full Policy","Mixed"]
["SETA",{"$f":"B16/B39","v":4.3694704435862208E-2},0.1,0.05]
["NSF",{"$f":"B8/B43","v":4.473070650565928E-2},1,0.1]
[]
["NSF Skills Programmes Scenario","Current",{"$f":"IF(B33=AL13,AM13,AM14)","v":0.18}]
[]
[]
[]
[]
["SETA Skills Programmes"]
["Status Quo",2044484.8935500174,2309864.2522784928,2581298.218273378,2881024.6390297557,3226490.9836060768,3530862.5265058908,3852171.0164179271,4202718.5789119583,4585165.9695929466,5002416.0728259059,5457635.9354530629,5954280.8055792907,6496120.3588870056,7087267.311545724,7732208.6368963839,8435839.6228539553,9203501.0285336655]
["Full Policy",2019429.7989115536,2309864.2522784928,2581298.218273378,2881024.6390297557,2647087.3650000002,2891966.5451249997,3155135.5007313751,3442252.8312979303,3755497.8389460421,4097248.1422901326,4470097.7232385343,4876876.6160532394,5320672.3881140854,5804853.5754324663,6333095.250796821,6909406.918619331,7538162.94821369]
["Mixed",2019429.7989115536,2309864.2522784928,2581298.218273378,2881024.6390297557,1785422.625,1952237.6381249996,2129891.2631943747,2323711.3681450631,2535169.1026462638,2765869.4909870746,3017563.6146668973,3292161.903601585,3591748.6368293292,3918597.7627807981,4275190.1591938511,4664232.4636804909,5088677.6178754158]
["NSF Skills Programmes"]
["Status Quo",{"$f":"B49*0.18","v":505152},{"$f":"C49*0.18","v":568800},635025.6,708735.60000000009,794070,866330.37,945166.43366999994,1031176.5791339701,1125013.6478351613,1227389.889788161,1339082.369758884,1460938.8654069419,1593884.3021589736,1738927.7736554402,1897170.2010580853,2069812.689354371,2258165.6440856187]
["Full Policy",{"$f":"B50*0.18","v":505152},568800,635025.6,708735.60000000009,{"$f":"F50*$C$33","v":794070},{"$f":"G50*$C$33","v":866330.37},945166.43366999994,1031176.5791339701,1125013.6478351613,1227389.889788161,1339082.369758884,1460938.8654069419,1593884.3021589736,1738927.7736554402,1897170.2010580853,2069812.689354371,2258165.6440856187]
["Mixed",505152,568800,635025.6,708735.60000000009,{"$f":"F51*$C$33","v":794070},{"$f":"G51*$C$33","v":866330.37},945166.43366999994,1031176.5791339701,1125013.6478351613,1227389.889788161,1339082.369758884,1460938.8654069419,1593884.3021589736,1738927.7736554402,1897170.2010580853,2069812.689354371,2258165.6440856187]
[]
[]
["NSF Training Programmes"]
["Status Quo",2806400,3160000,3527920,3937420.0000000005,4411500,4812946.5,5250924.6315000001,5728758.7729665004,6250075.8213064522,6818832.7210453395,7439346.4986604666,8116327.0300385663,8854912.7897720765,9660709.8536413349,10539834.450322697,11498959.385302061,12545364.689364549]
["Full Policy",2806400,3160000,3527920,3937420.0000000005,4411500,4812946.5,5250924.6315000001,5728758.7729665004,6250075.8213064522,6818832.7210453395,7439346.4986604666,8116327.0300385663,8854912.7897720765,9660709.8536413349,10539834.450322697,11498959.385302061,12545364.689364549]
["Mixed",2806400,3160000,3527920,3937420.0000000005,4411500,4812946.5,5250924.6315000001,5728758.7729665004,6250075.8213064522,6818832.7210453395,7439346.4986604666,8116327.0300385663,8854912.7897720765,9660709.8536413349,10539834.450322697,11498959.385302061,12545364.689364549]
[]
[]
[null,1000]

{"sheet":"TVET & CET Funding","index":10,"n_rows":35,"n_cols":20,"rows_kept":35,"cut":false,"hidden":true,"merged":[[25,0,34,0],[14,0,23,0],[3,0,12,0]]}
[]
[]
[null,null,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
["Status Quo","TVET",{"$f":"SUM(C5:C10)","v":495418454.32495373},{"$f":"SUM(D5:D10)","v":565639910.47858536},631616817.99872839,704933065.11463416,789783602.69051731,885126251.52514434,991981059.47424006,1111735665.573221,1245947367.9493451,1396361465.9240758,1564933956.0199668,1753856967.890192,1965587270.9415038,2202878222.3529429,2468815571.944798,2766857589.5070868,3100880036.4064374]
[null,"NCV Business",{"$f":"'[11]NSF Spend'!C10","v":7430096.3612903245},{"$f":"'[11]NSF Spend'!D10","v":8483070.9677419364},{"$f":"'[11]NSF Spend'!E10","v":9470758.1419354863},{"$f":"'[11]NSF Spend'!F10","v":10570067.496774197},{"$f":"'[11]NSF Spend'!G10","v":11842742.903225809},{"$f":"'[11]NSF Spend'!H10","v":13272430.494497946},{"$f":"'[11]NSF Spend'!I10","v":14874713.79483345},{"$f":"'[11]NSF Spend'!J10","v":16670429.019758683},{"$f":"'[11]NSF Spend'!K10","v":18682927.78845524},{"$f":"'[11]NSF Spend'!L10","v":20938380.790015556},{"$f":"'[11]NSF Spend'!M10","v":23466118.109100819},{"$f":"'[11]NSF Spend'!N10","v":26299010.636622407},{"$f":"'[11]NSF Spend'!O10","v":29473897.525340665},{"$f":"'[11]NSF Spend'!P10","v":33032065.249046635},{"$f":"'[11]NSF Spend'!Q10","v":37019784.495049164},{"$f":"'[11]NSF Spend'!R10","v":41488911.871758811},{"$f":"'[11]NSF Spend'!S10","v":46497564.256020211}]
[null,"NCV Technical",{"$f":"'[11]NSF Spend'!C11","v":14860192.722580649},{"$f":"'[11]NSF Spend'!D11","v":16966141.935483873},{"$f":"'[11]NSF Spend'!E11","v":18941516.283870973},{"$f":"'[11]NSF Spend'!F11","v":21140134.993548393},{"$f":"'[11]NSF Spend'!G11","v":23685485.806451619},{"$f":"'[11]NSF Spend'!H11","v":26544860.988995891},{"$f":"'[11]NSF Spend'!I11","v":29749427.589666899},{"$f":"'[11]NSF Spend'!J11","v":33340858.039517365},{"$f":"'[11]NSF Spend'!K11","v":37365855.576910481},{"$f":"'[11]NSF Spend'!L11","v":41876761.580031112},{"$f":"'[11]NSF Spend'!M11","v":46932236.218201637},{"$f":"'[11]NSF Spend'!N11","v":52598021.273244813},{"$f":"'[11]NSF Spend'!O11","v":58947795.05068133},{"$f":"'[11]NSF Spend'!P11","v":66064130.49809327},{"$f":"'[11]NSF Spend'!Q11","v":74039568.990098327},{"$f":"'[11]NSF Spend'!R11","v":82977823.743517622},{"$f":"'[11]NSF Spend'!S11","v":92995128.512040421}]
[null,"NATED (N1-N3)",{"$f":"'[11]NSF Spend'!C12","v":48295626.3483871},{"$f":"'[11]NSF Spend'!D12","v":55139961.290322579},{"$f":"'[11]NSF Spend'!E12","v":61559927.922580644},{"$f":"'[11]NSF Spend'!F12","v":68705438.729032278},{"$f":"'[11]NSF Spend'!G12","v":76977828.870967746},{"$f":"'[11]NSF Spend'!H12","v":86270798.214236632},{"$f":"'[11]NSF Spend'!I12","v":96685639.666417405},{"$f":"'[11]NSF Spend'!J12","v":108357788.62843142},{"$f":"'[11]NSF Spend'!K12","v":121439030.62495904},{"$f":"'[11]NSF Spend'!L12","v":136099475.13510111},{"$f":"'[11]NSF Spend'!M12","v":152529767.70915529},{"$f":"'[11]NSF Spend'!N12","v":170943569.13804561},{"$f":"'[11]NSF Spend'!O12","v":191580333.91471431},{"$f":"'[11]NSF Spend'!P12","v":214708424.11880308},{"$f":"'[11]NSF Spend'!Q12","v":240628599.21781951},{"$f":"'[11]NSF Spend'!R12","v":269677927.16643226},{"$f":"'[11]NSF Spend'!S12","v":302234167.66413128}]
[null,"NATED (N4-N6)",{"$f":"'[11]NSF Spend'!C13","v":44580578.167741932},{"$f":"'[11]NSF Spend'!D13","v":50898425.806451611},{"$f":"'[11]NSF Spend'!E13","v":56824548.851612896},{"$f":"'[11]NSF Spend'!F13","v":63420404.980645165},{"$f":"'[11]NSF Spend'!G13","v":71056457.419354826},{"$f":"'[11]NSF Spend'!H13","v":79634582.966987655},{"$f":"'[11]NSF Spend'!I13","v":89248282.769000679},{"$f":"'[11]NSF Spend'!J13","v":100022574.11855206},{"$f":"'[11]NSF Spend'!K13","v":112097566.7307314},{"$f":"'[11]NSF Spend'!L13","v":125630284.74009331},{"$f":"'[11]NSF Spend'!M13","v":140796708.65460488},{"$f":"'[11]NSF Spend'!N13","v":157794063.81973439},{"$f":"'[11]NSF Spend'!O13","v":176843385.15204394},{"$f":"'[11]NSF Spend'!P13","v":198192391.49427977},{"$f":"'[11]NSF Spend'!Q13","v":222118706.97029492},{"$f":"'[11]NSF Spend'!R13","v":248933471.23055279},{"$f":"'[11]NSF Spend'!S13","v":278985385.53612119}]
[null,"Learnerships",{"$f":"'[11]NSF Spend'!C14*[11]Assumptions!$B$68","v":343236560.22400004},{"$f":"'[11]NSF Spend'!D14*[11]Assumptions!$B$68","v":391879184},{"$f":"'[11]NSF Spend'!E14*[11]Assumptions!$B$68","v":437505826.20800006},{"$f":"'[11]NSF Spend'!F14*[11]Assumptions!$B$68","v":488288904.00800014},{"$f":"'[11]NSF Spend'!G14*[11]Assumptions!$B$68","v":547080702.60000002},{"$f":"'[11]NSF Spend'!H14*[11]Assumptions!$B$68","v":613125747.9347775},{"$f":"'[11]NSF Spend'!I14*[11]Assumptions!$B$68","v":687143927.74960947},{"$f":"'[11]NSF Spend'!J14*[11]Assumptions!$B$68","v":770097780.15942764},{"$f":"'[11]NSF Spend'!K14*[11]Assumptions!$B$68","v":863066043.45426357},{"$f":"'[11]NSF Spend'!L14*[11]Assumptions!$B$68","v":967257684.09511507},{"$f":"'[11]NSF Spend'!M14*[11]Assumptions!$B$68","v":1084027618.2069776},{"$f":"'[11]NSF Spend'!N14*[11]Assumptions!$B$68","v":1214894331.0125599},{"$f":"'[11]NSF Spend'!O14*[11]Assumptions!$B$68","v":1361559623.3311493},{"$f":"'[11]NSF Spend'!P14*[11]Assumptions!$B$68","v":1525930741.9276254},{"$f":"'[11]NSF Spend'!Q14*[11]Assumptions!$B$68","v":1710145181.4963815},{"$f":"'[11]NSF Spend'!R14*[11]Assumptions!$B$68","v":1916598480.80707},{"$f":"'[11]NSF Spend'!S14*[11]Assumptions!$B$68","v":2147975374.4753866}]
[null,"Learnerships (SETA)",{"$f":"'[11]SETA Discretionary'!C8*[11]Assumptions!$B$70","v":37015400.500953756},{"$f":"'[11]SETA Discretionary'!D8*[11]Assumptions!$B$70","v":42273126.478585333},{"$f":"'[11]SETA Discretionary'!E8*[11]Assumptions!$B$70","v":47314240.59072835},{"$f":"'[11]SETA Discretionary'!F8*[11]Assumptions!$B$70","v":52808114.90663401},{"$f":"'[11]SETA Discretionary'!G8*[11]Assumptions!$B$70","v":59140385.090517275},{"$f":"'[11]SETA Discretionary'!H8*[11]Assumptions!$B$70","v":66277830.925648674},{"$f":"'[11]SETA Discretionary'!I8*[11]Assumptions!$B$70","v":74279067.90471217},{"$f":"'[11]SETA Discretionary'!J8*[11]Assumptions!$B$70","v":83246235.607533842},{"$f":"'[11]SETA Discretionary'!K8*[11]Assumptions!$B$70","v":93295943.774025351},{"$f":"'[11]SETA Discretionary'!L8*[11]Assumptions!$B$70","v":104558879.58371978},{"$f":"'[11]SETA Discretionary'!M8*[11]Assumptions!$B$70","v":117181507.12192656},{"$f":"'[11]SETA Discretionary'!N8*[11]Assumptions!$B$70","v":131327972.00998488},{"$f":"'[11]SETA Discretionary'!O8*[11]Assumptions!$B$70","v":147182235.96757415},{"$f":"'[11]SETA Discretionary'!P8*[11]Assumptions!$B$70","v":164950469.06509507},{"$f":"'[11]SETA Discretionary'!Q8*[11]Assumptions!$B$70","v":184863730.77515453},{"$f":"'[11]SETA Discretionary'!R8*[11]Assumptions!$B$70","v":207180974.68775511},{"$f":"'[11]SETA Discretionary'!S8*[11]Assumptions!$B$70","v":232192415.96273774}]
[null,"Community Colleges",{"$f":"SUM(C12:C13)","v":30869175.570987467},{"$f":"SUM(D12:D13)","v":35251131.833491981},39427537.718155608,44005212.109256603,49287867.004713386,55236736.292504959,61905062.803101972,69378407.521445006,77753954.398225829,87140619.690537721,97660468.31727694,109450301.20075569,122663434.23643905,137471692.02466595,154067642.29099438,172667100.05174586,193511934.08911094,{"$f":"SUM(E11:S11)/1000","v":1471627.9697489298}]
[null,"Skills Programmes (NSF)",{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!C17","v":8485952.1600000001},{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!D17","v":9688560},{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!E17","v":10816602.720000001},{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!F17","v":12072129.720000003},{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!G17","v":13525659.000000002},{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!H17","v":15158512.722663442},{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!I17","v":16988488.913046621},{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!J17","v":19039384.722566493},{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!K17","v":21337870.158393614},{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!L17","v":23913834.902280923},{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!M17","v":26800776.998288825},{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!N17","v":30036238.4639319},{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!O17","v":33662293.489468016},{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!P17","v":37726095.573911153},{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!Q17","v":42280490.71276667},{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!R17","v":47384704.611429788},{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!S17","v":53105112.860823072}]
[null,"Skills Programmes (SETA)",{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!C12","v":22383223.410987467},{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!D12","v":25562571.833491977},{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!E12","v":28610934.998155605},{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!F12","v":31933082.3892566},{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!G12","v":35762208.004713386},{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!H12","v":40078223.569841519},{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!I12","v":44916573.890055351},{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!J12","v":50339022.798878513},{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!K12","v":56416084.239832215},{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!L12","v":63226784.788256802},{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!M12","v":70859691.318988115},{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!N12","v":79414062.736823782},{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!O12","v":89001140.746971041},{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!P12","v":99745596.450754791},{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!Q12","v":111787151.5782277},{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!R12","v":125282395.44031607},{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!S12","v":140406821.22828788}]
[]
["Full Policy","TVET",{"$f":"SUM(C16:C21)","v":495418454.32495373},{"$f":"SUM(D16:D21)","v":565639910.47858536},631616817.99872839,704933065.11463416,2455099362.5913448,2751476476.3243866,3083642074.1105752,3455907591.0863514,3873113996.7251577,4340686675.2802315,4864705977.8995628,5451986291.9808483,6110164655.9903908,6847800072.0999098,7674484808.1104279,8600969136.0420361,9639301129.4997711]
[null,"NCV Business",{"$f":"'[11]NSF Spend'!C38","v":7430096.3612903245},{"$f":"'[11]NSF Spend'!D38","v":8483070.9677419364},{"$f":"'[11]NSF Spend'!E38","v":9470758.1419354863},{"$f":"'[11]NSF Spend'!F38","v":10570067.496774197},{"$f":"'[11]NSF Spend'!G38","v":14452073.999999998},{"$f":"'[11]NSF Spend'!H38","v":16196767.018736273},{"$f":"'[11]NSF Spend'!I38","v":18152084.044077206},{"$f":"'[11]NSF Spend'!J38","v":20343452.169317618},{"$f":"'[11]NSF Spend'!K38","v":22799368.11444797},{"$f":"'[11]NSF Spend'!L38","v":25551768.799697418},{"$f":"'[11]NSF Spend'!M38","v":28636446.655705862},{"$f":"'[11]NSF Spend'!N38","v":32093515.071050521},{"$f":"'[11]NSF Spend'!O38","v":35967930.029842533},{"$f":"'[11]NSF Spend'!P38","v":40310074.722809166},{"$f":"'[11]NSF Spend'!Q38","v":45176414.734189048},{"$f":"'[11]NSF Spend'!R38","v":50630232.32454142},{"$f":"'[11]NSF Spend'!S38","v":56742449.358139716}]
[null,"NCV Technical",{"$f":"'[11]NSF Spend'!C39","v":14860192.722580649},{"$f":"'[11]NSF Spend'!D39","v":16966141.935483873},{"$f":"'[11]NSF Spend'!E39","v":18941516.283870973},{"$f":"'[11]NSF Spend'!F39","v":21140134.993548393},{"$f":"'[11]NSF Spend'!G39","v":28904147.999999996},{"$f":"'[11]NSF Spend'!H39","v":32393534.037472546},{"$f":"'[11]NSF Spend'!I39","v":36304168.088154413},{"$f":"'[11]NSF Spend'!J39","v":40686904.338635236},{"$f":"'[11]NSF Spend'!K39","v":45598736.22889594},{"$f":"'[11]NSF Spend'!L39","v":51103537.599394836},{"$f":"'[11]NSF Spend'!M39","v":57272893.311411723},{"$f":"'[11]NSF Spend'!N39","v":64187030.142101042},{"$f":"'[11]NSF Spend'!O39","v":71935860.059685066},{"$f":"'[11]NSF Spend'!P39","v":80620149.445618331},{"$f":"'[11]NSF Spend'!Q39","v":90352829.468378097},{"$f":"'[11]NSF Spend'!R39","v":101260464.64908284},{"$f":"'[11]NSF Spend'!S39","v":113484898.71627943}]
[null,"NATED (N1-N3)",{"$f":"'[11]NSF Spend'!C40","v":48295626.3483871},{"$f":"'[11]NSF Spend'!D40","v":55139961.290322579},{"$f":"'[11]NSF Spend'!E40","v":61559927.922580644},{"$f":"'[11]NSF Spend'!F40","v":68705438.729032278},{"$f":"'[11]NSF Spend'!G40","v":95142820.500000015},{"$f":"'[11]NSF Spend'!H40","v":106628716.20668049},{"$f":"'[11]NSF Spend'!I40","v":119501219.95684165},{"$f":"'[11]NSF Spend'!J40","v":133927726.781341},{"$f":"'[11]NSF Spend'!K40","v":150095840.08678249},{"$f":"'[11]NSF Spend'!L40","v":168215811.26467469},{"$f":"'[11]NSF Spend'!M40","v":188523273.81673029},{"$f":"'[11]NSF Spend'!N40","v":211282307.55108264},{"$f":"'[11]NSF Spend'!O40","v":236788872.69646341},{"$f":"'[11]NSF Spend'!P40","v":265374658.59182706},{"$f":"'[11]NSF Spend'!Q40","v":297411397.00007796},{"$f":"'[11]NSF Spend'!R40","v":333315696.13656443},{"$f":"'[11]NSF Spend'!S40","v":373554458.27441984}]
[null,"NATED (N4-N6)",{"$f":"'[11]NSF Spend'!C41","v":44580578.167741932},{"$f":"'[11]NSF Spend'!D41","v":50898425.806451611},{"$f":"'[11]NSF Spend'!E41","v":56824548.851612896},{"$f":"'[11]NSF Spend'!F41","v":63420404.980645165},{"$f":"'[11]NSF Spend'!G41","v":87916783.5},{"$f":"'[11]NSF Spend'!H41","v":98530332.69731234},{"$f":"'[11]NSF Spend'!I41","v":110425177.93480302},{"$f":"'[11]NSF Spend'!J41","v":123756000.69668218},{"$f":"'[11]NSF Spend'!K41","v":138696156.02955848},{"$f":"'[11]NSF Spend'!L41","v":155439926.86482596},{"$f":"'[11]NSF Spend'!M41","v":174205050.48887736},{"$f":"'[11]NSF Spend'!N41","v":195235550.01555735},{"$f":"'[11]NSF Spend'!O41","v":218804907.6815421},{"$f":"'[11]NSF Spend'!P41","v":245219621.23042247},{"$f":"'[11]NSF Spend'!Q41","v":274823189.63298339},{"$f":"'[11]NSF Spend'!R41","v":308000579.97429365},{"$f":"'[11]NSF Spend'!S41","v":345183233.59534997}]
[null,"Learnerships (NSF)",{"$f":"'[11]NSF Spend'!C42*[11]Assumptions!$B$68","v":343236560.22400004},{"$f":"'[11]NSF Spend'!D42*[11]Assumptions!$B$68","v":391879184},{"$f":"'[11]NSF Spend'!E42*[11]Assumptions!$B$68","v":437505826.20800006},{"$f":"'[11]NSF Spend'!F42*[11]Assumptions!$B$68","v":488288904.00800014},{"$f":"'[11]NSF Spend'!G42*[11]Assumptions!$C$68","v":2099693657.8799999},{"$f":"'[11]NSF Spend'!H42*[11]Assumptions!$C$68","v":2353174290.9287977},{"$f":"'[11]NSF Spend'!I42*[11]Assumptions!$C$68","v":2637255783.8171644},{"$f":"'[11]NSF Spend'!J42*[11]Assumptions!$C$68","v":2955632354.1729259},{"$f":"'[11]NSF Spend'!K42*[11]Assumptions!$C$68","v":3312444195.4544306},{"$f":"'[11]NSF Spend'!L42*[11]Assumptions!$C$68","v":3712331316.3453727},{"$f":"'[11]NSF Spend'!M42*[11]Assumptions!$C$68","v":4160493879.7853193},{"$f":"'[11]NSF Spend'!N42*[11]Assumptions!$C$68","v":4662759826.28936},{"$f":"'[11]NSF Spend'!O42*[11]Assumptions!$C$68","v":5225660660.9357233},{"$f":"'[11]NSF Spend'!P42*[11]Assumptions!$C$68","v":5856516389.561202},{"$f":"'[11]NSF Spend'!Q42*[11]Assumptions!$C$68","v":6563530708.6812124},{"$f":"'[11]NSF Spend'!R42*[11]Assumptions!$C$68","v":7355897686.9915419},{"$f":"'[11]NSF Spend'!S42*[11]Assumptions!$C$68","v":8243921325.7462587}]
[null,"Learnerships (SETA)",{"$f":"'[11]SETA Discretionary'!C30*[11]Assumptions!$B$70","v":37015400.500953756},{"$f":"'[11]SETA Discretionary'!D30*[11]Assumptions!$B$70","v":42273126.478585333},{"$f":"'[11]SETA Discretionary'!E30*[11]Assumptions!$B$70","v":47314240.59072835},{"$f":"'[11]SETA Discretionary'!F30*[11]Assumptions!$B$70","v":52808114.90663401},{"$f":"'[11]SETA Discretionary'!G30*[11]Assumptions!$C$70","v":128989878.71134467},{"$f":"'[11]SETA Discretionary'!H30*[11]Assumptions!$C$70","v":144552835.43538719},{"$f":"'[11]SETA Discretionary'!I30*[11]Assumptions!$C$70","v":162003640.26953444},{"$f":"'[11]SETA Discretionary'!J30*[11]Assumptions!$C$70","v":181561152.92744911},{"$f":"'[11]SETA Discretionary'!K30*[11]Assumptions!$C$70","v":203479700.81104207},{"$f":"'[11]SETA Discretionary'!L30*[11]Assumptions!$C$70","v":228044314.40626526},{"$f":"'[11]SETA Discretionary'!M30*[11]Assumptions!$C$70","v":255574433.84151798},{"$f":"'[11]SETA Discretionary'!N30*[11]Assumptions!$C$70","v":286428062.91169661},{"$f":"'[11]SETA Discretionary'!O30*[11]Assumptions!$C$70","v":321006424.5871343},{"$f":"'[11]SETA Discretionary'!P30*[11]Assumptions!$C$70","v":359759178.54803056},{"$f":"'[11]SETA Discretionary'!Q30*[11]Assumptions!$C$70","v":403190268.59358698},{"$f":"'[11]SETA Discretionary'!R30*[11]Assumptions!$C$70","v":451864475.9660123},{"$f":"'[11]SETA Discretionary'!S30*[11]Assumptions!$C$70","v":506414763.80932283}]
[null,"Community Colleges",{"$f":"SUM(C23:C24)","v":30869175.570987467},{"$f":"SUM(D23:D24)","v":35251131.833491981},39427537.718155608,44005212.109256603,305868080.86791134,342788734.88150996,384171107.5879609,430549270.98574716,482526330.28608191,540778199.17400479,606062389.44203556,679227861.7319051,761226065.48417068,853123311.66006994,956114639.13144171,1071539355.0583168,1200898451.3424497,{"$f":"SUM(E22:S22)/1000","v":8698306.5474610198}]
[null,"Skills Programmes (NSF)",{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!C45","v":8485952.1600000001},{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!D45","v":9688560},{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!E45","v":10816602.720000001},{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!F45","v":12072129.720000003},{"$f":"[11]Assumptions!$C$69*'[11]NSF Spend'!G45","v":240867900},{"$f":"[11]Assumptions!$C$69*'[11]NSF Spend'!H45","v":269946116.97893792},{"$f":"[11]Assumptions!$C$69*'[11]NSF Spend'!I45","v":302534734.06795353},{"$f":"[11]Assumptions!$C$69*'[11]NSF Spend'!J45","v":339057536.1552937},{"$f":"[11]Assumptions!$C$69*'[11]NSF Spend'!K45","v":379989468.57413292},{"$f":"[11]Assumptions!$C$69*'[11]NSF Spend'!L45","v":425862813.3282904},{"$f":"[11]Assumptions!$C$69*'[11]NSF Spend'!M45","v":477274110.92843115},{"$f":"[11]Assumptions!$C$69*'[11]NSF Spend'!N45","v":534891917.85084212},{"$f":"[11]Assumptions!$C$69*'[11]NSF Spend'!O45","v":599465500.49737573},{"$f":"[11]Assumptions!$C$69*'[11]NSF Spend'!P45","v":671834578.71348619},{"$f":"[11]Assumptions!$C$69*'[11]NSF Spend'!Q45","v":752940245.56981754},{"$f":"[11]Assumptions!$C$69*'[11]NSF Spend'!R45","v":843837205.40902376},{"$f":"[11]Assumptions!$C$69*'[11]NSF Spend'!S45","v":945707489.30232871}]
[null,"Skills Programmes (SETA)",{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!C34","v":22383223.410987467},{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!D34","v":25562571.833491977},{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!E34","v":28610934.998155605},{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!F34","v":31933082.3892566},{"$f":"[11]Assumptions!$C$71*'[11]SETA Discretionary'!G34","v":65000180.867911339},{"$f":"[11]Assumptions!$C$71*'[11]SETA Discretionary'!H34","v":72842617.902572021},{"$f":"[11]Assumptions!$C$71*'[11]SETA Discretionary'!I34","v":81636373.520007372},{"$f":"[11]Assumptions!$C$71*'[11]SETA Discretionary'!J34","v":91491734.830453455},{"$f":"[11]Assumptions!$C$71*'[11]SETA Discretionary'!K34","v":102536861.71194898},{"$f":"[11]Assumptions!$C$71*'[11]SETA Discretionary'!L34","v":114915385.84571443},{"$f":"[11]Assumptions!$C$71*'[11]SETA Discretionary'!M34","v":128788278.51360439},{"$f":"[11]Assumptions!$C$71*'[11]SETA Discretionary'!N34","v":144335943.88106295},{"$f":"[11]Assumptions!$C$71*'[11]SETA Discretionary'!O34","v":161760564.98679498},{"$f":"[11]Assumptions!$C$71*'[11]SETA Discretionary'!P34","v":181288732.94658375},{"$f":"[11]Assumptions!$C$71*'[11]SETA Discretionary'!Q34","v":203174393.56162414},{"$f":"[11]Assumptions!$C$71*'[11]SETA Discretionary'!R34","v":227702149.64929309},{"$f":"[11]Assumptions!$C$71*'[11]SETA Discretionary'!S34","v":255190962.04012108}]
[]
["Mixed","TVET",{"$f":"SUM(C27:C32)","v":495418454.32495373},{"$f":"SUM(D27:D32)","v":565639910.47858536},631616817.99872839,704933065.11463416,3991566145.2119775,4435838468.3398075,4971344749.8572035,5571498781.6457977,6244105012.9891376,6997910067.1577168,7842716483.17208,8789510188.7757339,9850603362.2862167,11039794541.110851,12372548058.990629,13866195145.38806,15540159302.130781]
[null,"NCV Business",{"$f":"'[11]NSF Spend'!C66","v":7430096.3612903245},{"$f":"'[11]NSF Spend'!D66","v":8483070.9677419364},{"$f":"'[11]NSF Spend'!E66","v":9470758.1419354863},{"$f":"'[11]NSF Spend'!F66","v":10570067.496774197},{"$f":"'[11]NSF Spend'!G66","v":374977500},{"$f":"'[11]NSF Spend'!H66","v":420245786.50567269},{"$f":"'[11]NSF Spend'!I66","v":470978981.60762},{"$f":"'[11]NSF Spend'!J66","v":527836823.68498099},{"$f":"'[11]NSF Spend'!K66","v":591558696.49819219},{"$f":"'[11]NSF Spend'!L66","v":662973244.19239342},{"$f":"'[11]NSF Spend'!M66","v":743009147.04975545},{"$f":"'[11]NSF Spend'!N66","v":832707198.11944282},{"$f":"'[11]NSF Spend'!O66","v":933233837.7706399},{"$f":"'[11]NSF Spend'!P66","v":1045896322.1730099},{"$f":"'[11]NSF Spend'!Q66","v":1172159722.9566753},{"$f":"'[11]NSF Spend'!R66","v":1313665979.116612},{"$f":"'[11]NSF Spend'!S66","v":1472255248.9138818}]
[null,"NCV Technical",{"$f":"'[11]NSF Spend'!C67","v":14860192.722580649},{"$f":"'[11]NSF Spend'!D67","v":16966141.935483873},{"$f":"'[11]NSF Spend'!E67","v":18941516.283870973},{"$f":"'[11]NSF Spend'!F67","v":21140134.993548393},{"$f":"'[11]NSF Spend'!G67","v":1124932500},{"$f":"'[11]NSF Spend'!H67","v":1260737359.5170181},{"$f":"'[11]NSF Spend'!I67","v":1412936944.8228598},{"$f":"'[11]NSF Spend'!J67","v":1583510471.0549428},{"$f":"'[11]NSF Spend'!K67","v":1774676089.4945762},{"$f":"'[11]NSF Spend'!L67","v":1988919732.5771801},{"$f":"'[11]NSF Spend'!M67","v":2229027441.1492662},{"$f":"'[11]NSF Spend'!N67","v":2498121594.3583283},{"$f":"'[11]NSF Spend'!O67","v":2799701513.3119192},{"$f":"'[11]NSF Spend'!P67","v":3137688966.5190296},{"$f":"'[11]NSF Spend'!Q67","v":3516479168.8700261},{"$f":"'[11]NSF Spend'!R67","v":3940997937.3498354},{"$f":"'[11]NSF Spend'!S67","v":4416765746.7416449}]
[null,"NATED (N1-N3)",{"$f":"'[11]NSF Spend'!C68","v":48295626.3483871},{"$f":"'[11]NSF Spend'!D68","v":55139961.290322579},{"$f":"'[11]NSF Spend'!E68","v":61559927.922580644},{"$f":"'[11]NSF Spend'!F68","v":68705438.729032278},{"$f":"'[11]NSF Spend'!G68","v":749955000},{"$f":"'[11]NSF Spend'!H68","v":840491573.01134539},{"$f":"'[11]NSF Spend'!I68","v":941957963.21524},{"$f":"'[11]NSF Spend'!J68","v":1055673647.369962},{"$f":"'[11]NSF Spend'!K68","v":1183117392.9963844},{"$f":"'[11]NSF Spend'!L68","v":1325946488.3847868},{"$f":"'[11]NSF Spend'!M68","v":1486018294.0995109},{"$f":"'[11]NSF Spend'!N68","v":1665414396.2388856},{"$f":"'[11]NSF Spend'!O68","v":1866467675.5412798},{"$f":"'[11]NSF Spend'!P68","v":2091792644.3460197},{"$f":"'[11]NSF Spend'!Q68","v":2344319445.9133506},{"$f":"'[11]NSF Spend'!R68","v":2627331958.2332239},{"$f":"'[11]NSF Spend'!S68","v":2944510497.8277636}]
[null,"NATED (N4-N6)",{"$f":"'[11]NSF Spend'!C69","v":44580578.167741932},{"$f":"'[11]NSF Spend'!D69","v":50898425.806451611},{"$f":"'[11]NSF Spend'!E69","v":56824548.851612896},{"$f":"'[11]NSF Spend'!F69","v":63420404.980645165},{"$f":"'[11]NSF Spend'!G69","v":599964000},{"$f":"'[11]NSF Spend'!H69","v":672393258.40907633},{"$f":"'[11]NSF Spend'!I69","v":753566370.57219195},{"$f":"'[11]NSF Spend'!J69","v":844538917.89596951},{"$f":"'[11]NSF Spend'!K69","v":946493914.39710736},{"$f":"'[11]NSF Spend'!L69","v":1060757190.7078295},{"$f":"'[11]NSF Spend'!M69","v":1188814635.2796087},{"$f":"'[11]NSF Spend'!N69","v":1332331516.9911084},{"$f":"'[11]NSF Spend'!O69","v":1493174140.4330237},{"$f":"'[11]NSF Spend'!P69","v":1673434115.4768159},{"$f":"'[11]NSF Spend'!Q69","v":1875455556.7306805},{"$f":"'[11]NSF Spend'!R69","v":2101865566.5865791},{"$f":"'[11]NSF Spend'!S69","v":2355608398.2622108}]
[null,"Learnerships",{"$f":"'[11]NSF Spend'!C70*[11]Assumptions!$B$68","v":343236560.22400004},{"$f":"'[11]NSF Spend'!D70*[11]Assumptions!$B$68","v":391879184},{"$f":"'[11]NSF Spend'!E70*[11]Assumptions!$B$68","v":437505826.20800006},{"$f":"'[11]NSF Spend'!F70*[11]Assumptions!$B$68","v":488288904.00800014},{"$f":"'[11]NSF Spend'!G70*[11]Assumptions!$C$68","v":650960939.99999952},{"$f":"'[11]NSF Spend'!H70*[11]Assumptions!$C$68","v":729546685.37384737},{"$f":"'[11]NSF Spend'!I70*[11]Assumptions!$C$68","v":817619512.0708276},{"$f":"'[11]NSF Spend'!J70*[11]Assumptions!$C$68","v":916324725.9171263},{"$f":"'[11]NSF Spend'!K70*[11]Assumptions!$C$68","v":1026945897.1208608},{"$f":"'[11]NSF Spend'!L70*[11]Assumptions!$C$68","v":1150921551.917994},{"$f":"'[11]NSF Spend'!M70*[11]Assumptions!$C$68","v":1289863879.2783744},{"$f":"'[11]NSF Spend'!N70*[11]Assumptions!$C$68","v":1445579695.9353516},{"$f":"'[11]NSF Spend'!O70*[11]Assumptions!$C$68","v":1620093942.3698297},{"$f":"'[11]NSF Spend'!P70*[11]Assumptions!$C$68","v":1815676015.2923439},{"$f":"'[11]NSF Spend'!Q70*[11]Assumptions!$C$68","v":2034869279.0527868},{"$f":"'[11]NSF Spend'!R70*[11]Assumptions!$C$68","v":2280524139.7464366},{"$f":"'[11]NSF Spend'!S70*[11]Assumptions!$C$68","v":2555835112.1144967}]
[null,"Learnerships (SETA)",{"$f":"'[11]SETA Discretionary'!C53*[11]Assumptions!$B$70","v":37015400.500953756},{"$f":"'[11]SETA Discretionary'!D53*[11]Assumptions!$B$70","v":42273126.478585333},{"$f":"'[11]SETA Discretionary'!E53*[11]Assumptions!$B$70","v":47314240.59072835},{"$f":"'[11]SETA Discretionary'!F53*[11]Assumptions!$B$70","v":52808114.90663401},{"$f":"'[11]SETA Discretionary'!G53*[11]Assumptions!$C$70","v":490776205.21197778},{"$f":"'[11]SETA Discretionary'!H53*[11]Assumptions!$C$70","v":512423805.52284777},{"$f":"'[11]SETA Discretionary'!I53*[11]Assumptions!$C$70","v":574284977.56846452},{"$f":"'[11]SETA Discretionary'!J53*[11]Assumptions!$C$70","v":643614195.72281516},{"$f":"'[11]SETA Discretionary'!K53*[11]Assumptions!$C$70","v":721313022.48201644},{"$f":"'[11]SETA Discretionary'!L53*[11]Assumptions!$C$70","v":808391859.37753296},{"$f":"'[11]SETA Discretionary'!M53*[11]Assumptions!$C$70","v":905983086.31556416},{"$f":"'[11]SETA Discretionary'!N53*[11]Assumptions!$C$70","v":1015355787.1326169},{"$f":"'[11]SETA Discretionary'!O53*[11]Assumptions!$C$70","v":1137932252.8595254},{"$f":"'[11]SETA Discretionary'!P53*[11]Assumptions!$C$70","v":1275306477.3036335},{"$f":"'[11]SETA Discretionary'!Q53*[11]Assumptions!$C$70","v":1429264885.4671123},{"$f":"'[11]SETA Discretionary'!R53*[11]Assumptions!$C$70","v":1601809564.3553722},{"$f":"'[11]SETA Discretionary'!S53*[11]Assumptions!$C$70","v":1795184298.2707822}]
[null,"Community Colleges",{"$f":"SUM(C34:C35)","v":30869175.570987467},{"$f":"SUM(D34:D35)","v":35251131.833491981},39427537.718155608,44005212.109256603,55925676.353185505,60403487.426786706,67695557.950424954,75867946.726981401,85026928.129956514,95291606.259401888,106795463.78081676,119688097.74401771,134137164.95470403,150330562.19648039,168478869.65511221,188818089.31949067,211612713.96968538,{"$f":"SUM(E33:S33)/1000","v":1603504.9142944566}]
[null,"Skills Programmes (NSF)",{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!C73","v":8485952.1600000001},{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!D73","v":9688560},{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!E73","v":10816602.720000001},{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!F73","v":12072129.720000003},{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!G73","v":26248425.000000004},{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!H73","v":29417205.05539709},{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!I73","v":32968528.712533403},{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!J73","v":36948577.657948673},{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!K73","v":41409108.754873455},{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!L73","v":46408127.093467541},{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!M73","v":52010640.293482885},{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!N73","v":58289503.868361004},{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!O73","v":65326368.6439448},{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!P73","v":73212742.552110702},{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!Q73","v":82051180.606967285},{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!R73","v":91956618.538162842},{"$f":"[11]Assumptions!$B$69*'[11]NSF Spend'!S73","v":103057867.42397173}]
[null,"Skills Programmes (SETA)",{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!C57","v":22383223.410987467},{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!D57","v":25562571.833491977},{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!E57","v":28610934.998155605},{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!F57","v":31933082.3892566},{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!G57","v":29677251.353185501},{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!H57","v":30986282.371389613},{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!I57","v":34727029.237891547},{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!J57","v":38919369.069032736},{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!K57","v":43617819.375083059},{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!L57","v":48883479.165934339},{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!M57","v":54784823.487333871},{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!N57","v":61398593.875656702},{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!O57","v":68810796.310759231},{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!P57","v":77117819.644369707},{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!Q57","v":86427689.048144907},{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!R57","v":96861470.781327844},{"$f":"[11]Assumptions!$B$71*'[11]SETA Discretionary'!S57","v":108554846.54571366}]

{"sheet":"Infrastructure","index":11,"n_rows":39,"n_cols":20,"rows_kept":39,"cut":false,"hidden":false,"merged":[[8,2,8,3]]}
[null,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030]
["Number of FTEs",{"$f":"Enrolments!C90","v":239629.02452156699},{"$f":"Enrolments!D90","v":267574.688173834},{"$f":"Enrolments!E90","v":310566.50079574069},{"$f":"Enrolments!F90","v":353558.31341764744},{"$f":"Enrolments!G90","v":396550.12603955413},{"$f":"Enrolments!H90","v":439541.93866146088},{"$f":"Enrolments!I90","v":482533.75128336763},{"$f":"Enrolments!J90","v":525525.56390527438},{"$f":"Enrolments!K90","v":568517.37652718113},{"$f":"Enrolments!L90","v":611509.18914908799},{"$f":"Enrolments!M90","v":654501.00177099474},{"$f":"Enrolments!N90","v":697492.81439290149},{"$f":"Enrolments!O90","v":740484.62701480824},{"$f":"Enrolments!P90","v":783476.43963671487},{"$f":"Enrolments!Q90","v":826468.25225862185},{"$f":"Enrolments!R90","v":869460.0648805286},{"$f":"Enrolments!S90","v":912451.87750243477},null,"Status Quo"]
["Change in FTEs",null,{"$f":"C2-B2","v":27945.663652267016},{"$f":"D2-C2","v":42991.812621906691},42991.812621906749,42991.812621906691,42991.812621906749,42991.812621906749,42991.812621906749,42991.812621906749,42991.812621906865,42991.812621906749,42991.812621906749,42991.812621906749,42991.812621906633,42991.812621906982,42991.812621906749,42991.812621906167]
["Number of FTEs",{"$f":"Enrolments!C98","v":239629.02452156699},{"$f":"Enrolments!D98","v":267574.688173834},{"$f":"Enrolments!E98","v":294703.0422955784},{"$f":"Enrolments!F98","v":321831.39641732286},{"$f":"Enrolments!G98","v":348959.7505390672},{"$f":"Enrolments!H98","v":376088.1046608116},{"$f":"Enrolments!I98","v":403216.458782556},{"$f":"Enrolments!J98","v":430344.8129043004},{"$f":"Enrolments!K98","v":457473.1670260448},{"$f":"Enrolments!L98","v":484601.52114778914},{"$f":"Enrolments!M98","v":511729.8752695336},{"$f":"Enrolments!N98","v":538858.229391278},{"$f":"Enrolments!O98","v":565986.58351302228},{"$f":"Enrolments!P98","v":593114.9376347668},{"$f":"Enrolments!Q98","v":620243.2917565112},{"$f":"Enrolments!R98","v":647371.64587825548},{"$f":"Enrolments!S98","v":674500},null,"full Policy"]
["Change in FTEs",null,{"$f":"C4-B4","v":27945.663652267016},27128.3541217444,27128.354121744458,27128.354121744342,27128.3541217444,27128.3541217444,27128.3541217444,27128.3541217444,27128.354121744342,27128.354121744458,27128.3541217444,27128.354121744283,27128.354121744516,27128.3541217444,27128.354121744283,27128.354121744516]
["Number of FTEs",{"$f":"Enrolments!C106","v":239424.46944811172},{"$f":"Enrolments!D106","v":259499.50260760472},{"$f":"Enrolments!E106","v":279574.53576709772},{"$f":"Enrolments!F106","v":299649.56892659073},{"$f":"Enrolments!G106","v":319724.60208608367},{"$f":"Enrolments!H106","v":339799.63524557685},{"$f":"Enrolments!I106","v":359874.66840506985},{"$f":"Enrolments!J106","v":379949.70156456286},{"$f":"Enrolments!K106","v":400024.73472405586},{"$f":"Enrolments!L106","v":420099.76788354886},{"$f":"Enrolments!M106","v":440174.80104304192},{"$f":"Enrolments!N106","v":460249.83420253493},{"$f":"Enrolments!O106","v":480324.86736202799},{"$f":"Enrolments!P106","v":500399.90052152105},{"$f":"Enrolments!Q106","v":520474.93368101405},{"$f":"Enrolments!R106","v":540549.96684050711},{"$f":"Enrolments!S106","v":560625},null,"Balanced"]
["Change in FTEs",null,{"$f":"C6-B6","v":20075.033159493003},20075.033159493003,20075.033159493003,20075.033159492945,20075.033159493178,20075.033159493003,20075.033159493003,20075.033159493003,20075.033159493003,20075.033159493061,20075.033159493003,20075.033159493061,20075.033159493061,20075.033159493003,20075.033159493061,20075.033159492887]
[]
[null,null,"Equipment costs"]
["Cost per square meter (inflation adjusted)",13000,"Basic",4000,"FTE to seats ratio",2.5]
[null,null,null,null,"FTE to enrolment",1.9263849269564655]
[]
["New campus estimates",null,null,"LEGEND"]
["Number of FTEs per campus",6000,null,null,"Heading"]
["Number of FTEs per campus",{"$f":"B14/F11","v":3114.6423105996378},null,null,"Item description"]
["Total cost of campus",453034103.3368125,null,null,"User-defined Input"]
["Average cost per new campus FTE",{"$f":"B16/B15","v":145453.01134421222},null,null,"Fixed Assumption"]
[null,null,null,null,"Output"]
["Existing campus expansion estimates",null,null,null,"Key output"]
["Ratio between expansion and new campus costs",{"$f":"1/3","v":0.33333333333333331}]
["Average cost per new campus FTE",{"$f":"B20*B17","v":48484.337114737405}]
[]
["Final cost per FTE to use (2014)"]
["Ratio of expanding existing and building new",{"$f":"1/3","v":0.33333333333333331}]
["Weighted cost (2014)",{"$f":"B24*B21+(1-B24)*B17*0.8","v":93736.38508849233}]
[]
[]
["Cost per FTE new infrastructure",{"$f":"B25","v":93736.38508849233},{"$f":"B28*(1+Expenditure!$C$9)/(1+Expenditure!$C$5)","v":99548.040963978856},{"$f":"C28*(1+Expenditure!$C$9)/(1+Expenditure!$C$5)","v":105720.01950374556},{"$f":"D28*(1+Expenditure!$C$9)/(1+Expenditure!$C$5)","v":112274.66071297778},{"$f":"E28*(1+Expenditure!$C$9)/(1+Expenditure!$C$5)","v":119235.68967718241},{"$f":"F28*(1+Expenditure!$C$9)/(1+Expenditure!$C$5)","v":126628.30243716773},{"$f":"G28*(1+Expenditure!$C$9)/(1+Expenditure!$C$5)","v":134479.25718827214},{"$f":"H28*(1+Expenditure!$C$9)/(1+Expenditure!$C$5)","v":142816.97113394502},{"$f":"I28*(1+Expenditure!$C$9)/(1+Expenditure!$C$5)","v":151671.62334424962},{"$f":"J28*(1+Expenditure!$C$9)/(1+Expenditure!$C$5)","v":161075.26399159309},{"$f":"K28*(1+Expenditure!$C$9)/(1+Expenditure!$C$5)","v":171061.93035907188},{"$f":"L28*(1+Expenditure!$C$9)/(1+Expenditure!$C$5)","v":181667.77004133436},{"$f":"M28*(1+Expenditure!$C$9)/(1+Expenditure!$C$5)","v":192931.17178389709},{"$f":"N28*(1+Expenditure!$C$9)/(1+Expenditure!$C$5)","v":204892.90443449872},{"$f":"O28*(1+Expenditure!$C$9)/(1+Expenditure!$C$5)","v":217596.26450943766},{"$f":"P28*(1+Expenditure!$C$9)/(1+Expenditure!$C$5)","v":231087.2329090228},{"$f":"Q28*(1+Expenditure!$C$9)/(1+Expenditure!$C$5)","v":245414.64134938223}]
["Proportion requiring infrastructure",0,{"$f":"Expenditure!$C$22","v":0},{"$f":"Expenditure!$C$22","v":0},{"$f":"Expenditure!$C$22","v":0},{"$f":"Expenditure!$C$22","v":0},{"$f":"Expenditure!$C$22","v":0},{"$f":"Expenditure!$C$22","v":0},{"$f":"Expenditure!$C$22","v":0},{"$f":"Expenditure!$C$22","v":0},{"$f":"Expenditure!$C$22","v":0},{"$f":"Expenditure!$C$22","v":0},{"$f":"Expenditure!$C$22","v":0},{"$f":"Expenditure!$C$22","v":0},{"$f":"Expenditure!$C$22","v":0},{"$f":"Expenditure!$C$22","v":0},{"$f":"Expenditure!$C$22","v":0},{"$f":"Expenditure!$C$22","v":0}]
["Total new infrastructure costs required",null,{"$f":"C3*B$28*Expenditure!$C$22","v":0},{"$f":"D3*D$28*D29","v":0},{"$f":"E3*D$28*E29","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C30:R30)","v":0},"Status Quo"]
["Total new infrastructure costs required",null,{"$f":"C5*B$28*Expenditure!$D$22*(1+Expenditure!$C$9)/(1+Expenditure!$C$5)","v":1390968035.010726},{"$f":"D5*C$28*Expenditure!$D$22*(1+Expenditure!$C$9)/(1+Expenditure!$C$5)","v":1434005063.4276669},{"$f":"E5*D$28*Expenditure!$D$22","v":1434005063.4276702},{"$f":"F5*E$28*Expenditure!$D$22","v":1522913377.3601792},{"$f":"G5*F$28*Expenditure!$D$22","v":1617334006.7565138},{"$f":"H5*G$28*Expenditure!$D$22","v":1717608715.1754179},{"$f":"I5*H$28*Expenditure!$D$22","v":1824100455.5162938},{"$f":"J5*I$28*Expenditure!$D$22","v":1937194683.7583041},{"$f":"K5*J$28*Expenditure!$D$22","v":2057300754.1513147},{"$f":"L5*K$28*Expenditure!$D$22","v":2184853400.9087057},{"$f":"M5*L$28*Expenditure!$D$22","v":2320314311.7650404},{"$f":"N5*M$28*Expenditure!$D$22","v":2464173799.0944629},{"$f":"O5*N$28*Expenditure!$D$22","v":2616952574.6383419},{"$f":"P5*O$28*Expenditure!$D$22","v":2779203634.2659073},{"$f":"Q5*P$28*Expenditure!$D$22","v":2951514259.5903811},{"$f":"R5*Q$28*Expenditure!$D$22","v":3134508143.6850119},{"$f":"SUM(D31:R31)","v":31995982243.521214},"Full Policy"]
["Total new infrastructure costs required",null,{"$f":"C7*B$28*Expenditure!$E$22","v":282264155.83537334},{"$f":"D7*C$28*Expenditure!$E$22","v":299764533.49716651},{"$f":"E7*D$28*Expenditure!$E$22","v":318349934.57399082},{"$f":"F7*E$28*Expenditure!$E$22","v":338087630.51757729},{"$f":"G7*F$28*Expenditure!$E$22","v":359049063.60967124},{"$f":"H7*G$28*Expenditure!$E$22","v":381310105.55346763},{"$f":"I7*H$28*Expenditure!$E$22","v":404951332.09778267},{"$f":"J7*I$28*Expenditure!$E$22","v":430058314.68784517},{"$f":"K7*J$28*Expenditure!$E$22","v":456721930.19849157},{"$f":"L7*K$28*Expenditure!$E$22","v":485038689.87079942},{"$f":"M7*L$28*Expenditure!$E$22","v":515111088.64278758},{"$f":"N7*M$28*Expenditure!$E$22","v":547047976.13864207},{"$f":"O7*N$28*Expenditure!$E$22","v":580964950.65923798},{"$f":"P7*O$28*Expenditure!$E$22","v":616984777.60010886},{"$f":"Q7*P$28*Expenditure!$E$22","v":655237833.81131756},{"$f":"R7*Q$28*Expenditure!$E$22","v":695862579.5076133},{"$f":"SUM(D32:R32)","v":7084540740.9664993},"Balanced"]
[]
[]
["Cost per sqm",128]
["Number of learners per sqm",2]
["Status Quo",{"$f":"B$6*$B$35/$B$36","v":15323166.04467915},{"$f":"C$6*$B$35/$B$36","v":16607968.166886702},17892770.289094254,19177572.411301807,20462374.533509355,21747176.655716918,23031978.777924471,24316780.900132023,25601583.022339575,26886385.144547127,28171187.266754683,29455989.388962235,30740791.511169791,32025593.633377347,33310395.755584899,34595197.877792455,35880000]
["Full Policy"]
["Mixed"]